Optimization and performance tuning

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




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

2015 ┬ęTutorsGlobe All rights reserved. TutorsGlobe Rated 4.8/5 based on 34139 reviews.