|
|
Posted by Erland Sommarskog on 09/11/06 21:18
bozzzza@lycos.co.uk (bozzzza@lycos.co.uk) writes:
> I have looked at the query execution plan, and 95% of the work is being
> done in various indexes.
Just because an index is used, does not mean that it is efficient. For
instance, if it says Clustered Index Scan, this usually means that the
entire table is scanned...
For a query like:
select top 10 *
from object
order by code
You want an index on code, clustered or non-clustered.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|