identify total rows changes to identify tables with Stale statistics

Database
Enthusiast

identify total rows changes to identify tables with Stale statistics

My goal is to build a script for gathering table statistics:

My main directive is to include tables with amount of changes (inserts. updates, deletes) more than specific percent (EX: 10%) from total table rows instead of using "not gathered for the last n days" approach.

Do there a dictionary view which displays amount of changes in the table (inserts, updates, deletes) which output compared to total rows of the table to decide which table stats is stale.

Regards

Tags (1)
3 REPLIES
Enthusiast

Re: identify total rows changes to identify tables with Stale statistics

keep updated

Enthusiast

Re: identify total rows changes to identify tables with Stale statistics

Detecting chqnge demographic is equally expensive as collecting stats, relying on row count fluctuations is a known good practice. You can obtain this information from the DBC table. Depending on the version of the database you can get the appropriate SQL from this forum if you search for postings on the stats topic by Mr.D.Noeth.
Enthusiast

Re: identify total rows changes to identify tables with Stale statistics

what will be best syntax to create  error count table and use it to count your tables Mload.