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 to enable/disable indexes?
Why do we use stored procedures in sql server?
Is truncate a dml command?
What is a coalesce function?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is ms sql server service broker?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is Federation and Federation Member?
How to transfer data from a cursor to variables with a "fetch" statement?
Explain syntax for viewing, dropping and disabling triggers?
What is intellisense?
What is the optimization being performed in oracle and SQL Server?
what is a check constraint?
What is the new security features added in sql server 2016? : sql server security
Name and describe few console utilities for ssrs?
