MicroStrategy ONE

Purge Statistics statement

Purges the statistics from all tables for all projects on this server.

Copy
PURGE 
 STATISTICS FROM start_dateTOend_date[TIMEOUTtimeout_secs];

where:

  • start_date is the start date for the statistics to be purged, of type date (mm/dd/yyyy).

  • end_date is the end date for the statistics to be purged, of type date (mm/dd/yyyy).

  • TIMEOUT timeout_secs is the timeout in seconds for the purging process, of type integer.

Example

Copy
PURGE STATISTICS FROM 4/1/2002 TO 5/1/2002 TIMEOUT 
 15;