Saves all cost model statistics in the database server cache.

Syntax

sa_flush_statistics( )

Remarks

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.

Permissions

DBA authority required

Side effects

None

See also

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