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 are drilldown reports?
What are the joins in sql server? : sql server database administration
How to provide login information for a new odbc dsn?
Differentiate sql server reporting services vs. Crystal reports?
How can a user-defined datatype be created?
What is the difference between a clustered index and a non-clustered index?
Explain what is the function of sql server agent windows service?
Explain the difference between delete,drop and truncate in SQL Server?
Tell about MOM Tool(Microsoft Operator Manager)?
What is difference between createstatement and preparedstatement?
How to access the deleted record of an event?
what stored procedure would you use to view lock information? : Sql server administration
Write down the syntax and an example for create, rename and delete index?
How can I tell if sql server is 32 or 64 bit?
How to define output parameters in stored procedures?