Teradata Question: Download Questions PDF
What is an optimization and performance tuning and how does it really work in practical projects?
Answer:
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.
index (to avoid skewness in storage) and using secondary index.
Avoiding NUSI is advisable.
Download Teradata Interview Questions And Answers
PDF
Previous Question | Next Question |
What is the difference between Global temporary tables and Volatile temporary tables? | What is explain and how does it work? |