View Single Post

   
  #3 (permalink)  
Old 02-29-2008, 08:51 AM
christopher.secord@gmail.com
 
Posts: n/a
Default Re: Key and Index on Same Column?

>If the table is wide, but some queries
>use only the primary key value, a scan of the nonclustered index will be
>faster than a scan of the clustered index.


Thanks. That's good info.

Reply With Quote