ποΈ 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.
