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
Can we check locks in database? If so, how can we do this lock check?
What are the advantages of user defined function?
What triggers long term care?
Explain the phases a transaction has to undergo?
What are magic tables in sql server?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is exclusive locks?
What is mean by dml?
What do you mean by authentication modes in sql server?
Is sql different from sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
How to change the system date and time from SQL Plus Terminal ?
What do you understand by check constraint in sql server?
What is the difference between indexing and hashing?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
