Performance Tuning in Teradata
Author(s):
Mahesh Khaire, Jasmeet Singh Birgi, Sahil Hira
Keywords:
DWH , Performance Turing , Teradata
Abstract
"Performance Tuning:- Increasing the System's Performance without making any hardware changes." Data is continuously increasing and most systems will respond to increased load with some degree of decreasing performance. A system's ability to accept higher load or to increase maximum load can be scaled up by inducing more nodes or by Improving hardware type, but the Question remains is it really What was required ? The most important question with the business will be if the change we are doing is really justified because adding additional hardware means additional cost to company and if Issue is not of Capacity/ Increasing Available CPU cycles that can be used adding more hardware will only increase the DWH cost for Organization. So the important thing becomes, if we are using the System resources in an Optimal way or something can be done to improve the performance without causing any additional cost to organization. Considering the Importance a lot of work has been done all over the world on DWH performance tuning, In this article we would like to share various approaches or Levels at which Performance Tuning can be done.
Article Details
Unique Paper ID: 142621

Publication Volume & Issue: Volume 2, Issue 5

Page(s): 46 - 51
Article Preview & Download


Share This Article

Conference Alert

NCSST-2021

AICTE Sponsored National Conference on Smart Systems and Technologies

Last Date: 25th November 2021

SWEC- Management

LATEST INNOVATION’S AND FUTURE TRENDS IN MANAGEMENT

Last Date: 7th November 2021

Latest Publication

Go To Issue



Call For Paper

Volume 8 Issue 4

Last Date 25 September 2021

About Us

IJIRT.org enables door in research by providing high quality research articles in open access market.

Send us any query related to your research on editor@ijirt.org

Social Media

Google Verified Reviews

Contact Details

Telephone:6351679790
Email: editor@ijirt.org
Website: ijirt.org

Policies