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.

Answer / midhu

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

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.

What is nolock?

0 Answers  

---

What is explicit cursors?

0 Answers  

---

How to provide default values to stored procedure parameters?

0 Answers  

---

How can I get data from a database on another server?

0 Answers  

---

How to perform backup for certificates in sql server? : sql server security

0 Answers  

---

What is sql or structured query language?

0 Answers  

---

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

Do you know what is sql injection?

0 Answers  

---

How to check table values in sql server?

0 Answers  

---

Explain about link server in sql server?

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---