explain plan for
select *
from comr_clerk_vou c
where c.vou_type = '11'
and c.sub_vou_type = '0'
and c.vou_status like '%0%';
acc
select * from table(dbms_xplan.display());
---drop index COMR_CLERK_VOU_IDX3;
---create index COMR_CLERK_VOU_IDX3 on COMR_CLERK_VOU (VOU_TYPE,SUB_VOU_TYPE, VOU_STATUS)
Plan hash value: 4001598363
---------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 124 | 14756 | 122 (0)| 00:00:02 |
| 1 | TABLE ACCESS BY INDEX ROWID| COMR_CLERK_VOU | 124 | 14756 | 122 (0)| 00:00:02 |
|* 2 | INDEX RANGE SCAN | COMR_CLERK_VOU_IDX3 | 124 |
索引访问中的access和filter
最新推荐文章于 2022-10-04 23:08:10 发布