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 the difference between having clause and where clause in sql server?

0 Answers  

---

How to sort the query output with order by clauses in ms sql server?

0 Answers  

---

What is a functions and types in sql server?

0 Answers  

---

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

---

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

---

Is Sql non procedural query language?

1 Answers   Verifone,

---

Explain transaction server consistency?

0 Answers  

---

What are orphan records?

0 Answers  

---

What is the maximum size of column in sql server?

0 Answers  

---

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

---

What is a trigger and its types?

0 Answers  

---

Tell me what is the difference between locking and multi-versioning?

0 Answers  

---