dbms_stats收集统计信息

-- gather table stats

exec dbms_stats. gather_table_stats(ownname =>'your schema name',

tabname =>'your table name',

estimate_percent=>100,

method_opt =>'FOR TABLE',

cascade =>TRUE);

--gather index stats

exec dbms_stats.gather_index_stats(ownname =>' your schema name