Statistics Requests list

Lists the manual active, pending, and error requests on the system, as well as the automatic active, candidate, and error requests.

Table
Specifies the long table name.

Schema
Specifies the schema name.

Partition
Specifies the partition name.

Columns
Specifies the name of the column(s) for which statistics will be collected. Sometimes, numbers preceded by * will appear instead of the column name (for example, *0001). This generally happens when a request has not moved to error status but as the list was created it was determined that the column(s) requested for statistics no longer exist or were damaged. Once the entry is processed it will move to *error status and the particular error message can be viewed using Details.

Database
Specifies the name of the database in which the statistics will be collected.

Status
Specifies the status for the statistics request. Possible values for status are:

Active - Indicates that the request is currently being processed.

Error - Indicates a problem with the request. To determine the problem, click Details.

Pending - Indicates that the request initiated by a user is waiting to run.

Candidate - Indicates that the statistic was identified by the database as potentially useful. It will be gathered automatically if time permits.

Estimated time
Specifies the approximate amount of time, in seconds, that is required to process the request.

Submitted
Specifies the date that the item was requested.

Requester
Specifies the name of the requester (user profile) that requested statistics to be created or updated. System indicates that the create or update was system-generated, while a specific name indicates the user profile of the person who requested the create or update.