what is Covering Index ?

Answers were Sorted based on User's Feedback



what is Covering Index ?..

Answer / rajesh kumar

An index is used to quickly locate the data record from
which the required data is read. In other words, the index
is only used to locate data records in the table and not to
return data.

A covering index is a special case where the index itself
contains the required data field and can return the data.

Is This Answer Correct ?    6 Yes 0 No

what is Covering Index ?..

Answer / midhu

- Index covering means that "Data can be found only using indexes, without touching the tables"

Is This Answer Correct ?    0 Yes 0 No

what is Covering Index ?..

Answer / 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

More SQL Server Interview Questions

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  


What is left outer join in sql server joins?

0 Answers  


How to change the ownership of a schema in ms sql server?

0 Answers  


What is difference between views and tables?

0 Answers  


What is isnull() operator?

0 Answers  






What are partitioned views and distributed partitioned views?

0 Answers  


What is repeatable read?

0 Answers  


What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  


What is bulkcopy in sql?

0 Answers  


What is the recovery model?

0 Answers  


What is difference between clustered index and non clustered index?

0 Answers  


1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  


Categories