Saturday, March 11, 2017

SQL Performance Issue Checks and Tuning

First checks:
  • Check the statistics to make sure that they are the latest
  • No missing indexes

The suspects:
  • Distinct
  • Group by, Order by
  • Sub Queries in WHERE Clause
  • Nested Views
Quick checks for solution:
  • Reduce the number of joins
  • Reduce number of tables joined in single query
  • Reduce the data sorting in the query



Copyright © Tech Notes