ORACLE回表(三)
来源:互联网 发布:李世民杀兄 知乎 编辑:程序博客网 时间:2024/06/07 07:18
http://www.itpub.net/thread-1340290-1-1.html
“回表”一般就是指执行计划里显示的“TABLE ACCESS BY INDEX ROWID”。
例如select的字段里有索引不包含的列,
SQL> select ename from emp where empno =1;
Execution Plan
----------------------------------------------------------
Plan hash value: 4066871323
----------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
----------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 8 | 1 |
| 1 | TABLE ACCESS BY INDEX ROWID | EMP | 1 | 8 | 1 |
|* 2 | INDEX UNIQUE SCAN | PK_EMP | 1 | | 1 |
----------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("EMPNO"=1)
再例如,虽然只查询索引里的列,但是需要回表过滤掉其他行。
SQL> select empno from emp where empno =1 and ename='hao';
Execution Plan
----------------------------------------------------------
Plan hash value: 4066871323
----------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
----------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 8 | 1 |
|* 1 | TABLE ACCESS BY INDEX ROWID| EMP | 1 | 8 | 1 |
|* 2 | INDEX UNIQUE SCAN | PK_EMP | 1 | | 1 |
----------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("ENAME"='hao')
2 - access("EMPNO"=1)
例如select的字段里有索引不包含的列,
SQL> select ename from emp where empno =1;
Execution Plan
----------------------------------------------------------
Plan hash value: 4066871323
----------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
----------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 8 | 1 |
| 1 | TABLE ACCESS BY INDEX ROWID | EMP | 1 | 8 | 1 |
|* 2 | INDEX UNIQUE SCAN | PK_EMP | 1 | | 1 |
----------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("EMPNO"=1)
再例如,虽然只查询索引里的列,但是需要回表过滤掉其他行。
SQL> select empno from emp where empno =1 and ename='hao';
Execution Plan
----------------------------------------------------------
Plan hash value: 4066871323
----------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
----------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 8 | 1 |
|* 1 | TABLE ACCESS BY INDEX ROWID| EMP | 1 | 8 | 1 |
|* 2 | INDEX UNIQUE SCAN | PK_EMP | 1 | | 1 |
----------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("ENAME"='hao')
2 - access("EMPNO"=1)
- ORACLE回表(三)
- oracle 学习(三)
- Oracle学习(三)
- oracle期末(三)
- oracle体系结构(三)
- oracle自学(三)
- Oracle(三)老师
- Oracle百问百答(三)
- Oracle脚本(三)
- oracle基础(三)
- oracle 基础知识(三)
- Oracle游标(三)
- Oracle-BPM(三)
- Oracle初探(三)
- Oracle笔记(三)
- Oracle-BPM(三)
- Oracle基础知识(三)
- oracle(三)
- SQL Server 脚本大小写
- ORACLE回表(二)
- ubuntu 挂载windwos分区
- hibernate 学习汇总(更新ing)
- B Conic Section
- ORACLE回表(三)
- hdu 1231 最大连续子序列
- Servlet中forward和redirect的区别(转)
- GnomeSort 又是一个O(n2),不过,只用一次循环……
- c文件
- oracle 10G表空间页面打开慢(非常慢)的解决方法
- MTK手机软件系统工程和配置简介
- jQuery验证框架
- IO 输入与输出(7)-- ObjectInputStream和ObjectOutputStream类