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
How will you make an attribute not process? : sql server analysis services, ssas
Explain throw statement in sql server 2008?
What is the report model project?
What is built-in/administrator?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is a sql join?
What is create statement?
Does view occupy space?
What are different types of raid levels?
What is difference between sql and sql server?
How to access the inserted record of an event?
Why do we use non clustered index?
define and explain the differences between clustered and non-clustered indexes.
What is the difference between clustered and a non-clustered index?
What does select 1 mean?