What does a covering index do for a query?

SQL Data Analyst Medium

SQL Data Analyst — Medium

What does a covering index do for a query?

Key points

  • Covering index includes all query columns
  • Reduces I/O by avoiding table access
  • Improves query performance by fetching data from the index
  • Does not physically order table data like a clustered index

Ready to go further?

Related questions