索引访问中的access和filter_zhaoyangjian724的专栏

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 |  explain plan for 
select * 
  from comr_clerk_v