-- 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 ----------------------------------------------------------------------------
index fast full scan
最新推荐文章于 2021-11-21 11:00:52 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)