太懒
发布时间：2014-09-10 18:01:03
Oracle 查看统计信息SCRIPT - Select to show Optimizer Statistics for CBO (Doc ID 31412.1)https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=1638430201757426&id=31412.1&_adf.ctrl-state=17ud5ixo9v_65 [oracle@my2950 admin]$ cd /u01/app/oracle/product/11.2.4/db_1/rdbms/admin[oracle@my2950 ad.........【阅读全文】
发布时间：2014-09-10 15:00:38
使用DBMS_XPLAN查看执行计划SQL> show user;USER is "SCOTT"SQL>SQL> select count(*) from dba_objects; COUNT(*)---------- 87091SQL> create table t2 as select * from dba_objects;Table created.SQL>SQL> create index idx_t2 on t2(OBJECT_ID);Index created.SQL> SQL> exec dbms_sta.........【阅读全文】
