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.
what will be best syntax to create error count table and use it to count your tables Mload.