统计更新

analyze table my_table compute statistics; 

DBMS_STATS.gather_table_stats(OWNNAME => 'USERNAME',TABNAME => 'TABLE_NAME');
DBMS_STATS.gather_index_stats('USERNAME','INDEX_NAME');