iteye_20195的博客

首先确定系统类型一:OLAP => ALL_ROWS二:OLTP =》 FIRST_ROWS查询oracle，optimizer_modeshow parameter optimizer_mode修改:alter system set optimizer_mode=FIRST_ROWS

数据库表、索引、列信息EXECUTE SYS.dbms_stats.gather_table_stats(user,'T_USER');select * from dba_tab_statistics where table_name='T_USER';select * from dba_ind_statistics where table_name='T_USER';selec...