[font="Verdana"]
pankaj (4/13/2008)
Can some one please explain in detail?
How does it differ from covering index?
A query is covered if all the columns it uses come from one or more indexes. These columns include the columns you want the query to return as well as columns in any JOIN, WHERE, HAVING, and ORDER BY clause.
for more information, check it out ...
http://www.sql-server-performance.com/articles/per/benchmark_covering_indexes_p1.aspx
Mahesh
[/font]