Teradata Question:
Download Questions PDF

What is an optimization and performance tuning and how does it really work in practical projects?


Performance tuning and optimization of a query involves collecting statistics on join columns, avoiding cross product join, selection of appropriate primary

index (to avoid skewness in storage) and using secondary index.

Avoiding NUSI is advisable.

Download Teradata Interview Questions And Answers PDF

Previous QuestionNext Question
What is the difference between Global temporary tables and Volatile temporary tables?What is explain and how does it work?