Covering Indexes

List down the advantage and disadvantages of Covering indexes.

Questions by psingla   answers by psingla

Showing Answers 1 - 3 of 3 Answers

Lokesh M

  • Dec 12th, 2011
 

Covering Indexes are useful for Input / Output intensive workloads.
Covering indexes are smaller in size
Covering Indexes are sorted by values
It is easier to cache date in Covering Indexes

Covering Indexes cannot be used to select all the columns / entire table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions