Teradata Interview Question:

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