Viewing 2 posts - 1 through 2 (of 2 total)
Thank for your help!
but I run below two SQL statements,and can find executed plan for them.
this is why?
select * from northwind.dbo.customers
select * from northwind.dbo.customers where customerid='ANTON'
April 18, 2009 at 1:46 am
#980127
I think it will be execute with clustered index when we only select the columns which have clustered index .
I'm a novice, could you please give some knowledge about...
April 11, 2009 at 2:53 am
#976018