Optimization and performance tuning

What do you mean by optimization and performance tuning and explain how does it actually work in the practical projects?

E

Expert

Verified

Performance tuning and optimization of a query includes collecting the statistics on join columns, ignoring cross product join, selection of suitable primary index (to avoid skewness in storage) and utilizing the secondary index and avoiding the NUSI is advisable.

   Related Questions in Database Management System