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

Submitted by: Administrator
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.
Submitted by: Administrator

Read Online Teradata Job Interview Questions And Answers