what are the factors should consider to increase the performance of query? Is there any automation tool where we can dump whole query an check the recommendations like we have in microsoft sql ( sql profiler). Can any one provide me the link for sample videos on teradata sql tuning/optimisation or any guide for begginers? and also in teradata viewpoint what are limitation we have to check to avoid long running queries?
my questions looks simple to all but please help me to understand the concept of Tuning terdata sql's.
Thanks alot guys.
Factors can be size of tables, wrong choice of PIs, joins , stale stats etc etc.
Teradata is so rich in terms of tools. You can have a look at explain or tools like TD index wizard, TVE,TSET, TD workload analyzer if you have access to. Take your QCD and play with it.
Viewpoint is for monitoring