Database Statistics Summary Table

This table returns one row for each database on which an UPDATE STATS has been executed.

Table 4. sysdbstats
Column Name Description
dbname Name of database
lastrun Date when this UPDATE STATS was run.
exectime The execution time in seconds.
rowtot The total rows in the database when this UPDATE STATS was run.
autopct The AUTORUN percent value.
automin The AUTORUN minimum rows value.
histosize The maximum number of histogram values per column.
samplepct The SAMPLING percent value.
samplemin The SAMPLING minimum rows value.
samplemax The SAMPLING maximum rows value.
notabs The SAMPLING of tables in the database