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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx