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
Tell me what is the significance of null value and why should we avoid permitting null values?
What according to you is the difference between mysql and sql server performance?
What is multilevel indexing?
What are SSL and TSL protocols?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is sql stored procedure?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How to see the event list of an existing trigger using sys.trigger_events?
What are the different Topologies in which Replication can be configured?
what does the automatic recovery do? : Sql server administration
What is the sql server 2000 version number?
Explain what is analysis service repository?
What is the contrast between sql and pl/sql?
How do you set a trace flag in sql server?
