Updating Number of Rows

When you run UPDATE STATISTICS LOW, the database server updates the statistics in the table, row, and page counts in the system catalog tables.

Run UPDATE STATISTICS LOW as often as necessary to ensure that the statistic for the number of rows is as current as possible. If the cardinality of a table changes often, run the statement more often for that table.

LOW is the default mode for UPDATE STATISTICS. The following sample SQL statement updates the statistics in the systables, syscolumns, and sysindexes system catalog tables but does not update the data distributions:

UPDATE STATISTICS FOR TABLE tab1;