夜拿水果刀

摘要： 原来语句执行计划 SELECT t1.*, t2.owner FROM t1, t2 WHERE t1.object_name LIKE '%T1%' AND t1.object_id = t2.object_id; 原来语句执行计划 SELECT t1.*, t2.owner FROM t1, t 阅读全文

摘要： SQL>create table t1 as select object_id,object_name from dba_objects where rownumcreate table t2 as select * from dba_objects; SQL>create index t2_idx on t2(object_id); SQL>exec dbms_stats.... 阅读全文

摘要： --##################################################### --#### AWR执行计划 #### --##################################################### <!--WizRtf2Html Ch 阅读全文