Share via

What is storage principal of Non cover and Cover Index

Sudip Bhatt 2,281 Reputation points
2020-09-19T09:29:23.547+00:00

Please anyone discuss how data is stored for Non cover and Cover Index with a sample example. thanks

SQL Server | Other
0 comments
Answer accepted by question author
  1. AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff
    2020-09-21T06:46:42.37+00:00

    Hi @Sudip Bhatt ,

    When an index contains all the columns referenced by a query it is typically referred to as covering the query. A covering index is an index which is used in a covering query.
    Please refer to the following articles which might help:
    Create Indexes with Included Columns
    SQL Server covering index and key lookup performance
    What are Covering Indexes and Covered Queries in SQL Server

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,616 Reputation points
    2020-09-19T10:05:46.23+00:00

    stored for Non cover and Cover Index

    There are no such index type by definition; if an index covers a query simply depends on the index definition and the query.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.