Answer Posted / 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 |
Post New Answer View All Answers
How to rebuild indexes with alter index ... Rebuild?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Explain SSRS Architecture?
How to configure odbc dsn with different port numbers?
What are the differences between char and nchar in ms sql server?
Explain Normalization and DE normalization
Explain full-text query in sql server?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Can binary strings be used in arithmetical operations?
What is data source document?
What is the difference between web edition and business edition?
What does the on update no action do?
What is bit data type?
Which database stores information about replication?
What are the steps you should follow to start sql server in single-user mode?