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

  • January 28, 2011 at 2:48 am

    #1279586

    rja.carnegie (9/2/2009)

    I find the report of DBCC CHECKDB useful.

    Why doesn't "SELECT COUNT(*) FROM table" look at an index, which apparently it doesn't(?)

    For 'select count(*) from

    ' the 2008 optimiser will scan the PK of the table if it has one. Not as good as (some of) the DMV queries, but not as bad as a full table scan.