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
Do you know what is fill factor and pad index?
what's the information that can be stored inside a bit column? : Sql server database administration
How to find Duplicate Records In table?
How you trouble shoot when any job fails
What is difference between group by and having?
What is data source object?
Do you know exporting and importing utility?
What are various aggregate functions that are available?
Explain a join?
What is the distinction amongst delete and truncate?
What are commonly used mssql functions in php?
What are distinctive joins find as a part of sql?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
How do you rebuild an identity column?
How column data types are determined in a view?