Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Christoffer Hedgate Advice on using COUNT( ) RE: Advice on using COUNT( )

  • September 24, 2002 at 4:05 am

    #437165

    Chris it is DBCC UPDATEUSAGE.

    quote:

    Specifies that the rows column of sysindexes is updated with the current count of the number of rows in the table or view. This applies only to sysindexes rows that have an indid of 0 or 1. This option can affect performance on large tables and indexed views.

    However 2000 seems to be a little less troublesome about this issue. 7 was and to my knowledge even with SP4 is still notorious for incorrect values.

    Good article.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

    Edited by - antares686 on 09/24/2002 04:06:27 AM