|
Posted by Erland Sommarskog on 04/16/06 01:42
Peter (someone@someplace.com) writes:
> I dont know exactly why but some say:
>
> A select * from makes sql server does a table scan.
>
> Is that true,
No. A query like:
SELECT * FROM sometable WHERE primarykey = 12
will use the index on PK.
--
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]
|