Teradata Interview Question

Explain performance optimisation and primary indexes