Mladen Prajdić Blog

Blog about stuff and things and stuff. Mostly about SQL server and .Net

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.

Legacy Comments


raja
2006-05-18
re: Clustered Index seek and scan on selecting all data from a table
hi

Mladen
2006-05-18
re: Clustered Index seek and scan on selecting all data from a table
hi :))