create table a3 as select * from dba_objects
create index a3_idx1 on a3(owner);
select owner from a3 where owner='SCOTT';
SQL> set linesize 200
SQL> set pagesize 200
SQL> set autot trace
SQL> select owner from a3 where owner='SCOTT';
1870 rows selected.
Execution Plan
----------------------------------------------------------
Plan hash value: 3836947260
----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1870 | 31790 | 5 (0)| 00:00:01 |
|* 1 | INDEX RANGE SCAN| A3_IDX1 | 1870 | 31790 | 5 (0)| 00:00:01 |
----------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access(
INDEX RANG SCAN无需回表的情况
最新推荐文章于 2021-04-08 06:00:25 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)