Tag: "index"

increasing the performance of count(*)

Posted on Jan 26, 2011 by in Useless for most people...
The fastest count(*) can be archived if you create a secondary index on top of a clustered index only containing the clustered key Carefull this is an index that will be used only here ...   more »
4 comments »