ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
Saves all cost model statistics in the database server cache.
sa_flush_statistics ()
DBA authority required
None
Database administrators can use this procedure to ensure that cost model statistics in the database server cache that have been created and/or gathered but not yet saved to disk are flushed out with immediate effect. 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.