index fast full scan

-- Create table
create table TEST
(
  farendma VARCHAR2(4) default '' not null,
  mingxibh VARCHAR2(32) default '' not null,
  dkzhangh VARCHAR2(32) default '' not null,
  dkjiejuh VARCHAR2(35) default '' not null,
  huobdhao VARCHAR2(3),
  yngyjigo VARCHAR2(12) default '',
  jiaoyirq VARCHAR2(8),
  
   jiluztai VARCHAR2(1) not null
)
partition by range (JIAOYIRQ)
(
  partition TEST_P170914 values less than ('20170915')
    tablespace V7TLHX_DATA_TBS_01
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 8M
      next 1M
      minextents 1
      maxextents unlimited
    ),
    

explain plan for select * from TESTa where a.jiaoyirq >='20180907' and a.jiaoyirq<='20180913';

select * from table(dbms_xplan.display());

       PLAN_TABLE_OUTPUT
1    Plan hash value: 2638207556
2     
3    ----------------------------------------------------------------------------