Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kendal Van Dyke How To Get Table Row Counts Quickly And Painlessly RE: How To Get Table Row Counts Quickly And Painlessly
matt stockham
SSCrazy Eights
Points: 9942
More actions
September 2, 2009 at 8:58 am
#1048213
rja.carnegie (9/2/2009)Why doesn't "SELECT COUNT(*) FROM table" look at an index, which apparently it doesn't(?)
rja.carnegie (9/2/2009)
It should pick the smallest index (by page reads).