Interested to Buy Any Domain ? << Click Here >> for more details...
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 do use Having,Group by,Group function in SQL?
Ms sql server index?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to execute the cursor queries with "open" statements?
How to recompile stored procedure at run time?
How do I find the sql server database version?
What does executeupdate return?
How can I create a new template for import ? : sql server management studio
How to create new table with "create table" statements?
Explain query editor regions
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What options are available to audit login activity? : sql server security
How to delete duplicate rows?
How to replace given values with null using nullif()?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
