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
What information is maintained within the msdb database?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
How do you clear a log file?
When would you use it?
Explain indexing and what are the advantages of it?
Can sub report data source be different from that of the parent report?
What is the maximum length of an alert name?
What is trigger explain with program?
How to count groups returned with the group by clause in ms sql server?
what is the difference between count(*) and count(1) ?
What is row_number () and partition by in sql server?
How to delete existing triggers using "drop trigger"?
How to find related tables in sql server?
How to delete existing rows in a table?
What are the types of stored procedures in an sql server?