Jobs in Pune | Work better in teams | Socialize with friends | Submit Q&A | Tell a friend

Search site for 

• What is “index covering” of a query?

   3,714 Views  |   (18 votes, avg: 3.61)

   Loading ...
    

Answers »

1. Submitted By: sprihak — October 6, 2006 +5 votes   + -

   Index covering means that “Data can be found only using indexes, without touching the tables”

3. Submitted By: artidesai — October 6, 2006 +3 votes   + -

   A nonclustered index that includes (or covers) all columns used in a query is called a covering index.
   When SQL server can use a nonclustered index to resolve the query, it will prefer to scan the index rather than the table, which typically takes fewer data pages. If your query uses only columns included in the index, then SQL server may scan this index to produce the desired output.

4. Leave an Answer/Comment

   Name (required)

   Mail (will not be published) (required)

   Your Answer

   To prove you're a person (not a spam script), type the security text shown in the picture. Click here to regenerate some new text.
   

Contact Us | FAQ | Sitemap | Terms of Use | Privacy Policy | Tell a Friend

Copyright © 1999-2006 Jeeve Technologies LLC. All rights reserved.