[转]通过分析SQL语句的执行计划优化SQL (七)[3]
来源:互联网 发布:appcleaner mac 破解 编辑:程序博客网 时间:2024/06/04 19:01
1 0 HASH JOIN (Cost=5 Card=1 Bytes=110)
2 1 HASH JOIN (Cost=3 Card=1 Bytes=84)
3 2 TABLE ACCESS (FULL) OF 'C' (Cost=1 Card=1 Bytes=26)
4 2 TABLE ACCESS (FULL) OF 'A' (Cost=1 Card=82 Bytes=4756)
5 1 TABLE ACCESS (FULL) OF 'B' (Cost=1 Card=1 Bytes=26)
select /*+ ORDERED USE_NL (A C)*/ A.col4
from C , A , B
where C.col3 = 5 and A.col1 = B.col1 and A.col2 = C.col2
and B.col3 = 10;
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=4 Card=1 Bytes=110)
1 0 HASH JOIN (Cost=4 Card=1 Bytes=110)
2 1 NESTED LOOPS (Cost=2 Card=1 Bytes=84)
3 2 TABLE ACCESS (FULL) OF 'C' (Cost=1 Card=1 Bytes=26)
4 2 TABLE ACCESS (FULL) OF 'A' (Cost=1 Card=82 Bytes=4756)
5 1 TABLE ACCESS (FULL) OF 'B' (Cost=1 Card=1 Bytes=26)
创建索引:
create index inx_col12A on a(col1,col2);
select A.col4
from C , A , B
where C.col3 = 5 and A.col1 = B.col1 and A.col2 = C.col2
and B.col3 = 10;
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 MERGE JOIN
2 1 SORT (JOIN)
3 2 NESTED LOOPS
4 3 TABLE ACCESS (FULL) OF 'B'
5 3 TABLE ACCESS (BY INDEX ROWID) OF 'A'
6 5 INDEX (RANGE SCAN) OF 'INX_COL12A' (NON-UNIQUE)
7 1 SORT (JOIN)
8 7 TABLE ACCESS (FULL) OF 'C'
select /*+ ORDERED */ A.col4
from C , A , B
where C.col3 = 5 and A.col1 = B.col1 and A.col2 = C.col2
and B.col3 = 10;
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=5 Card=1 Bytes=110)
1 0 HASH JOIN (Cost=5 Card=1 Bytes=110)
2 1 HASH JOIN (Cost=3 Card=1 Bytes=84)
3 2 TABLE ACCESS (FULL) OF 'C' (Cost=1 Card=1 Bytes=26)
4 2 TABLE ACCESS (FULL) OF 'A' (Cost=1 Card=82 Bytes=4756)
5 1 TABLE ACCESS (FULL) OF 'B' (Cost=1 Card=1 Bytes=26)
select /*+ ORDERED USE_NL (A C)*/ A.col4
from C , A , B
where C.col3 = 5 and A.col1 = B.col1 and A.col2 = C.col2
and B.col3 = 10;
Execution Plan
----------------------------------------------------------
转自 http://it.educity.cn/oracle/200712281702191698.htm- [转]通过分析SQL语句的执行计划优化SQL (七)[3]
- [转]通过分析SQL语句的执行计划优化SQL (七)[2]
- [转]通过分析SQL语句的执行计划优化SQL (七)[1]
- [转]通过分析SQL语句的执行计划优化SQL (七)[4]
- [转]通过分析SQL语句的执行计划优化SQL (七)[5]
- 通过分析SQL语句的执行计划优化SQL (七)
- 通过分析SQL语句的执行计划优化SQL(七)(2)
- 通过分析SQL语句的执行计划优化SQL(七)(1)
- [转]通过分析SQL语句的执行计划优化SQL
- 通过分析SQL语句的执行计划优化SQL
- 通过分析SQL语句的执行计划优化SQL
- 通过分析SQL语句的执行计划优化SQL
- 通过分析SQL语句的执行计划优化SQL
- 通过分析SQL语句的执行计划优化SQL(三)
- 通过分析SQL语句的执行计划优化SQL(五)
- 通过分析SQL语句的执行计划优化SQL
- 通过分析SQL语句的执行计划优化SQL(总结)
- 通过分析SQL语句的执行计划优化SQL
- [转]通过分析SQL语句的执行计划优化SQL (七)[2]
- [转]通过分析SQL语句的执行计划优化SQL (七)[1]
- 出现错误信息:Configuration Error
- C#2.0类和对象学习系列之构造函数
- 二分法插入排序
- [转]通过分析SQL语句的执行计划优化SQL (七)[3]
- RGB/YUV Pixel Conversion
- 07年10大CEO言论
- [转]通过分析SQL语句的执行计划优化SQL (七)[4]
- [转]通过分析SQL语句的执行计划优化SQL (七)[5]
- WaitForMultipleObjects
- 关于“This file has been modified outside of the source editor. Do you want to reload it?”错误的处理
- 实战JBossMQ JMS集群
- 安装新的nt9中断 动态 显示26字母,"ESC"改变颜色