奥客

摘要： 首先创建四个临时表t1,t2,t3,t4,和他们相对应的索引 复制内容到剪贴板 代码:create table t1 as select * from user_objects;create table t2 as select * from user_objects;create table t3 as select * from user_objects;create table t4 as select * from user_objects;create unique index pk_t1_idx on t1(object_id);create unique index pk_t2_ 阅读全文

摘要： --使用执行计划explain plan set statement_id='test1' for select * from dual;--查询执行计划SELECT A.OPERATION,A.OPTIONS,A.OBJECT_NAME,A.OBJECT_TYPE,A.ID,A.PARENT_ID,a.cost,a.io_cost,a.cpu_cost,A.*FROM PLAN_TABLE aWHERE A.STATEMENT_ID='test1'ORDER BY A.Id;--创建查询执行计划的表rem rem $Header: utlxplan.sql 2 阅读全文