Query Optimization

• Updating Statistics
• Checking Statistics Information
• Viewing Query Plan
• Query Profiling
• Using SQL Hint
• Index Hint
  • USING INDEX
  • USE, FORCE, IGNORE INDEX
  • Examples of index hint
• Special Indexes
  • Filtered Index
  • Function-based Index
• Optimization using indexes
  • Covering Index
  • Optimizing ORDER BY Clause
  • Index Scan in Descending Order
  • Optimizing GROUP BY Clause
  • Multiple Key Ranges Optimization
  • Index Skip Scan
  • Loose Index Scan
  • In Memory Sort
  • SORT-LIMIT optimization