April 13, 2008 at 10:59 pm
Can some one please explain in detail?
How does it differ from covering index?
April 14, 2008 at 12:41 am
Hi there,
Maybe this link will help:
http://www.mssqltips.com/tip.asp?tip=1206
Kind regards,
Oana Schuster.
April 14, 2008 at 3:06 am
[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]
MH-09-AM-8694
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply