DROP ANALYZE JOB

Description

Delete the history of the specified statistics collection job.

Syntax

DROP ANALYZE JOB <job_id>

Required Parameters

<job_id>

Specifies the id of the job. You can obtain the job_id by running SHOW ANALYZE. For detailed usage, please refer to the "SHOW ANALYZE" section.

Access Control Requirements

The user executing this SQL command must have at least the following privileges:

Privilege	Object	Notes
SELECT_PRIV	Table

Examples

Delete the statistics information job record with id 10036

DROP ANALYZE JOB 10036