sa_flush_statistics( )

Use this procedure to flush current cost model statistics in the database, currently cached, to disk. You can then retrieve the statistics using the sa_get_histogram system procedure, or the Histogram utility (dbhist). When this system procedure runs, the ISYSCOLSTAT system table is updated. Under normal operation it should not be necessary to execute this procedure because the server automatically writes out statistics to disk on a periodic basis.

DBA authority

None

• sa_get_histogram system procedure
• SYSCOLSTAT system view
• Histogram utility (dbhist)