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
Tell me what is normalization? Explain different forms of normalization?
What do you do in data exploration
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What different steps will a sql server developer take to secure sql server?
can a database be shrunk with users active? : Sql server administration
What are the joins in sql server? : sql server database administration
What is database replication? What are the different types of replication you can set up in sql server?
Where is trigger in sql server?
Explain the truncate command? : SQL Server Architecture
What does it mean to manipulate data?
What does the on delete cascade option do?
what are isolation levels? : Sql server database administration
What is relationship? What number of sorts of relationship are there?
How to assign null values to variables or columns?
What does truncate do?