What is a covering index?

SQL Data Analyst Hard

SQL Data Analyst — Hard

What is a covering index?

Key points

  • Covering index contains all query columns
  • Eliminates table access for data retrieval
  • Improves query performance by reducing I/O operations

Ready to go further?

Related questions