what is Covering Index ?

Answer Posted / rajesh kumar

An index is used to quickly locate the data record from
which the required data is read. In other words, the index
is only used to locate data records in the table and not to
return data.

A covering index is a special case where the index itself
contains the required data field and can return the data.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you make an attribute not process? : sql server analysis services, ssas

594


Explain throw statement in sql server 2008?

585


What is the report model project?

103


What is built-in/administrator?

580


what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

544






What is a sql join?

578


What is create statement?

541


Does view occupy space?

528


What are different types of raid levels?

560


What is difference between sql and sql server?

552


How to access the inserted record of an event?

584


Why do we use non clustered index?

560


define and explain the differences between clustered and non-clustered indexes.

605


What is the difference between clustered and a non-clustered index?

601


What does select 1 mean?

540