Oracle 常用指令 & SQL - Analyze 篇 (Analyze section)

analyze 相關指令

-- 分析Index

analyze index [schema].index_name validate structure online;
select * from dbms_stats;

-- 分析Index (CBO)

analyze index [schema].index_name compute statistics;

-- 分析Table (table only)

analyze table [schema].table_name validate structure online;

-- 分析Table (include index)

analyze table [schema].table_name validate structure cascade online;