- 博客(5)
- 资源 (13)
- 收藏
- 关注
原创 操作FILTER 的优化
SQL> explain plan for select * from emp where job='CLERK' and 1=2; SQL> select * from table(dbms_xplan.display); 0 SELECT STATEMENT *1 FILTER 2 TABLE ACCESS BY INDEX ROWID *3 INDEX
2012-05-31 22:00:46 385
原创 COUNT STOPKEY的优化
SQL> explain plan for select * from emp where rownum 2 ; Explained. SQL> select * from table(dbms_xplan.display); 0 SELECT STATEMENT 1 COUNT STOPKEY 2 TABLE ACCESS FULL 1-f
2012-05-31 21:51:45 2123
原创 单独型操作
SQL> explain plan for select deptno,count(*) from emp where job='CLERK' and sal SQL> select * from table(dbms_xplan.display); 0 SELECT STATEMENT 1 HASH GROUP BY 2 TABLE ACCESS FU
2012-05-31 21:37:03 318
原创 查询计划表
explain plan for select * from emp where deptno=10 order by ename; select * from table(dbms_xplan.display); 1.SELECT STATEMENT 2. SORT ORDER B Y 3. TABLE ACCESS FULLE
2012-05-31 21:10:20 307
转载 查询计划表
explain plan for select * from emp where deptno=10 order by ename; select * from table(dbms_xplan.display); 1.SELECT STATEMENT 2. SORT ORDER B Y 3. TABLE ACCESS FULLE
2012-05-31 21:05:07 261
druid-mysql demo
2016-09-03
使用 VMware Server 在 Oracle Enterprise Linux 上安装 Oracle RAC 10g
2011-05-11
Redhat 5.4安装oracle 9.2.0.4补丁和RPM包(二)
2010-08-15
Redhat Enterprice 5.4 安装oracle 9.2.0.4补丁和RPM包(一)
2010-08-15
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人