What are Covering Indexes and Covered Queries in SQL Server?

by

A covering index is one which can satisfy all requested columns in a query without performing a further lookup into the clustered index.

There is no such thing as a covering query.

Have a look at this Simple-Talk article: Using Covering Indexes to Improve Query Performance.

More Related Contents:

  1. How important is the order of columns in indexes?
  2. Creating an index on a table variable
  3. SQL Server indexes – ascending or descending, what difference does it make?
  4. Does Foreign Key improve query performance?
  5. How to create a unique index on a NULL column?
  6. What’s the difference between a Table Scan and a Clustered Index Scan?
  7. Slow bulk insert for table with many indexes
  8. Find number of days that intersect a given date range in a table of date ranges
  9. Convert Rows to columns using ‘Pivot’ in SQL Server
  10. SQL Server : Columns to Rows
  11. SQL NVARCHAR and VARCHAR Limits
  12. Why no windowed functions in where clauses?
  13. Using a Variable in OPENROWSET Query
  14. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  15. How to get the first and last date of the current year?
  16. Why execute stored procedures is faster than SQL query from a script?
  17. T-SQL – Aliasing using “=” versus “as” [closed]
  18. How to install localdb separately?
  19. How to escape square brackets inside square brackets for field name
  20. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  21. Cumulative Total in MS Sql server [duplicate]
  22. What does ON [PRIMARY] mean?
  23. SQL query to group by day
  24. Export table data from one SQL Server to another
  25. Should I use the CASCADE DELETE rule? [duplicate]
  26. Dynamic order direction
  27. Why is RAND() not producing random numbers?
  28. SQL, How to Concatenate results?
  29. Should every SQL Server foreign key have a matching index? [closed]
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment