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.
Loading...
Related Quiz
- How does MySQL Workbench aid in the process of database design and management?
- Which of the following statements best describes denormalization?
- How does clustering contribute to data storage optimization?
- What are the main advantages of using clustering in a distributed database system?
- What is the primary goal of storage optimization in database systems?