An index that contains a subset of the columns of a table and includes only the columns frequently used in queries is known as a _______ index.

  • Composite
  • Covering
  • Dense
  • Sparse
A covering index is one that includes a subset of the columns of a table, often those frequently used in queries. This type of index can significantly improve query performance by allowing the database engine to fulfill queries using the index alone, without accessing the actual table.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *