ANALYZE TABLE
ANALYZE TABLE creates a manual collection task for collecting CBO statistics.
CREATE ANALYZE
CREATE ANALYZE customizes an automatic collection task for collecting CBO statistics.
DROP ANALYZE
DROP ANALYZE deletes a custom collection task.
DROP STATS
DROP STATS deletes CBO statistics, which include basic statistics and histograms.
KILL ANALYZE
KILL ANALYZE cancels a **running** collection task, including manual and custom automatic tasks.
SHOW ANALYZE JOB
SHOW ANALYZE JOB views the information and status of custom collection tasks.
SHOW ANALYZE STATUS
SHOW ANALYZE STATUS views the status of collection tasks.
SHOW META
SHOW META views metadata of CBO statistics, including basic statistics and histograms.