Alter Statistics statement

Modifies the statistics properties for a registered/loaded project in a MicroStrategy Intelligence Server.

ALTER STATISTICS [DBINSTANCE "stats_dbinstance_name"] BASICSTATS (ENABLED | DISABLED) [DETAILEDREPJOBS (TRUE | FALSE)] [DETAILEDDOCJOBS (TRUE | FALSE)] [JOBSQL (TRUE | FALSE)] [COLUMNSTABLES (TRUE | FALSE)] [PROMPTANSWERS (TRUE | FALSE)] [SUBSCRIPTIONDELIVERIES (TRUE | FALSE)] [SQLTIMEOUT sql_seconds] [PURGETIMEOUT purge_seconds] IN PROJECT "project_name";

where:

  • DBINSTANCE stats_dbinstance_name is the database instance to be used for the statistics in a project, of type string.

  • SQLTIMEOUT sql_seconds is the length of time, in seconds, before the statistics writing times out, of type integer.

  • PURGETIMEOUT purge_seconds is the length of time, in seconds, before the statistics purge times out, of type integer.

  • PROJECT project_name is the project for which the statistics properties will be modified, of type string.

Example

ALTER STATISTICS DBINSTANCE "Statistics" ENABLED USERSESSIONS TRUE CACHES TRUE DOCUMENTS TRUE BASICREPJOBS TRUE DETAILEDREPJOBS FALSE IN PROJECT "MicroStrategy Tutorial";