I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

Clustered Index seek and scan on selecting all data from a table

I stumbled on an interesting thing yesterday while playing... :))
Seems that getting all data from a table is faster if we add a "phantom" where part
that forces a clustered index seek instead of a scan.

More here.

Print | posted on Tuesday, April 04, 2006 2:45 PM | Filed Under [ SQL Server ]

Feedback

Gravatar

# re: Clustered Index seek and scan on selecting all data from a table

hi
5/18/2006 8:52 AM | raja
Gravatar

# re: Clustered Index seek and scan on selecting all data from a table

hi :))
5/18/2006 10:38 AM | Mladen
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET