Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can you please explain the difference between primary keys and foreign keys?
How can I track the changes or identify the latest insert-update-delete from a table?
What are the acid properties?
What is a trigger and types of a trigger?
What is difference between table aliases and column aliases? Do they affect performance?
What is tcl in sql server?
Is sql server difficult to learn?
What are ddl (data definition language) statements for tables in ms sql server?
What are the advantages of user-defined functions over stored procedures in sql server?
What is built-in/administrator?
What is the difference between dbcc indexdefrag and dbcc reindex?
What is the correct order of the logical query processing phases?
What are the different types of cursor?
What are the drawbacks of reporting in ssrs?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
