# Overview A covering index is... #flashcard an index that includes all columns needed for a *specific* query in the index itself to avoid looking up the data in the table. <!--ID: 1751507776893--> # Key Considerations # Pros - Speeds up queries that only require a small subset of columns # Cons # Use Cases - Queries that select a small subset of columns # Related Topics