12 Query optimization tips for better performance
====================================================
Tip 1: Add missing indexes
Tip 2: Check for unused indexes
Tip 3: Avoid using multiple OR in the FILTER predicate
Tip 4: Use wildcards at the end of a phrase only
Tip 5: Avoid too many JOINs
Tip 6: Avoid using SELECT DISTINCT
Tip 7: Use SELECT fields instead of SELECT *
Tip 8: Use TOP to sample query results
Tip 9: Run the query during off-peak hours
Tip 10: Minimize the usage of any query hint
Tip 11: Minimize large write operations
Tip 12: Create joins with INNER JOIN (not WHERE)