what is Covering Index ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / midhu
- Index covering means that "Data can be found only using indexes, without touching the tables"
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / saikat mukherjee
The observed improvement is due to the fact that the
nonclustered index contained all of the required information
to resolve the query. No Key Lookups were required. An index
that contains all information required to resolve the query
is known as a "Covering Index"; it completely covers the query.
Is This Answer Correct ? | 1 Yes | 2 No |
Explain Trigger with an example?
What is table-valued sub query?
How to change the ownership of a schema in ms sql server?
What is schemabinding a view?
How do I find the port number for sql server?
Questions regarding Raiseerror?
What is difference beteen Migration and Upgrdation?
Explain trigger classes i.e. Instead of and after trigger?
What does Master database contains?
how to find maximum identity number in a table ?
2 Answers JPMorgan Chase, Thomson Reuters, Wipro,
Can a function call a stored procedure in sql server?
How to use values from other tables in update statements in ms sql server?