Answer
A covering index contains all columns needed for a query.
SQL Server can return results from the index alone without touching the table.
This greatly improves performance for read-heavy queries.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ