Oracle重建表索引

exec dbms_stats.gather_table_stats(OWNNAME=>'表空间'，

tabname=>'表名',

degree=>4,

estinate_percent => dbms_stats.auto_sample_size,

cascade => TRUE,

method_opt =>'for all columns size 1',

no_invalidate => false

);