Oracle建完索引后要analyze一下才行!
execute dbms_stats.gather_table_stats( ownname=>'BTA', tabname=>'BTAM003TB', partname=> NULL, estimate_percent=>100, cascade=>TRUE, degre...