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;