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