很长时间，BOSS系统查询库存记录表一直都很慢，语句也不复杂，这张表的数据量有2-3千万，之后考虑对这张表创建分区表，来提高访问速度,具体如下:
CREATE TABLESPACE STOCK_TS01 DATAFILE
'+DATA/yesmynet/datafile/stock_TS01.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS02 DATAFILE
'+DATA/yesmynet/datafile/stock_TS02.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS03 DATAFILE
'+DATA/yesmynet/datafile/stock_TS03.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS04 DATAFILE
'+DATA/yesmynet/datafile/stock_TS04.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS05 DATAFILE
'+DATA/yesmynet/datafile/stock_TS05.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS06 DATAFILE
'+DATA/yesmynet/datafile/stock_TS06.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS07 DATAFILE
'+DATA/yesmynet/datafile/stock_TS07.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS08 DATAFILE
'+DATA/yesmynet/datafile/stock_TS08.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS09 DATAFILE
'+DATA/yesmynet/datafile/stock_TS09.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS10 DATAFILE
'+DATA/yesmynet/datafile/stock_TS10.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS11 DATAFILE
'+DATA/yesmynet/datafile/stock_TS11.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS12 DATAFILE
'+DATA/yesmynet/datafile/stock_TS12.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS13 DATAFILE
'+DATA/yesmynet/datafile/stock_TS13.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS14 DATAFILE
'+DATA/yesmynet/datafile/stock_TS14.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS15 DATAFILE
'+DATA/yesmynet/datafile/stock_TS15.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS16 DATAFILE
'+DATA/yesmynet/datafile/stock_TS16.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS17 DATAFILE
'+DATA/yesmynet/datafile/stock_TS17.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS18 DATAFILE
'+DATA/yesmynet/datafile/stock_TS18.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS19 DATAFILE
'+DATA/yesmynet/datafile/stock_TS19.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS20 DATAFILE
'+DATA/yesmynet/datafile/stock_TS20.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS21 DATAFILE
'+DATA/yesmynet/datafile/stock_TS21.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS22 DATAFILE
'+DATA/yesmynet/datafile/stock_TS22.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS23 DATAFILE
'+DATA/yesmynet/datafile/stock_TS23.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS24 DATAFILE
'+DATA/yesmynet/datafile/stock_TS24.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS25 DATAFILE
'+DATA/yesmynet/datafile/stock_TS25.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS26 DATAFILE
'+DATA/yesmynet/datafile/stock_TS26.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS27 DATAFILE
'+DATA/yesmynet/datafile/stock_TS27.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS28 DATAFILE
'+DATA/yesmynet/datafile/stock_TS28.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS29 DATAFILE
'+DATA/yesmynet/datafile/stock_TS29.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS30 DATAFILE
'+DATA/yesmynet/datafile/stock_TS30.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS31 DATAFILE
'+DATA/yesmynet/datafile/stock_TS31.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS32 DATAFILE
'+DATA/yesmynet/datafile/stock_TS32.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS33 DATAFILE
'+DATA/yesmynet/datafile/stock_TS33.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS34 DATAFILE
'+DATA/yesmynet/datafile/stock_TS34.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS35 DATAFILE
'+DATA/yesmynet/datafile/stock_TS35.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS36 DATAFILE
'+DATA/yesmynet/datafile/stock_TS36.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS37 DATAFILE
'+DATA/yesmynet/datafile/stock_TS37.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS38 DATAFILE
'+DATA/yesmynet/datafile/stock_TS38.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS39 DATAFILE
'+DATA/yesmynet/datafile/stock_TS39.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS40 DATAFILE
'+DATA/yesmynet/datafile/stock_TS40.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE STOCK_TS41 DATAFILE
'+DATA/yesmynet/datafile/stock_TS41.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS01;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS02;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS03;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS04;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS05;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS06;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS07;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS08;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS09;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS10;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS11;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS12;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS13;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS14;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS15;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS16;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS17;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS18;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS19;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS20;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS21;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS22;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS23;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS24;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS25;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS26;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS27;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS28;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS29;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS30;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS31;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS32;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS33;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS34;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS35;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS36;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS37;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS38;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS39;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS40;
ALTER USER MYNET_APP QUOTA UNLIMITED ON STOCK_TS41;
create table m_stock_record_k
(
RECORD_ID NUMBER(14) primary key,
HOUSE_ID NUMBER(12) not null,
BLOCK_ID NUMBER(12),
LOCATION_ID NUMBER(12),
BAR_CODE VARCHAR2(20),
SUBMIT_USER_ID NUMBER(12),
GOODS_ID NUMBER(12),
GOODS_AMOUNT NUMBER,
CHANGE_REASON VARCHAR2(100),
SUBMIT_DATE DATE not null,
OLD_STOCK_AMOUNT NUMBER,
GOODS_TYPE VARCHAR2(50),
INOUT_TYPE VARCHAR2(50),
INOUT_ID NUMBER(12),
HOUSE_TYPE VARCHAR2(50),
VERSION INTEGER,
GOODS_LINE VARCHAR2(50),
SHEET_NO VARCHAR2(100)
)
partition by range(SUBMIT_DATE)
(
partition part_01 values less than(to_date('2010-01-01','yyyy-mm-dd')) tablespace STOCK_TS01,
partition part_02 values less than(to_date('2010-08-01','yyyy-mm-dd')) tablespace STOCK_TS02,
partition part_03 values less than(to_date('2010-11-01','yyyy-mm-dd')) tablespace STOCK_TS03,
partition part_04 values less than(to_date('2010-12-01','yyyy-mm-dd')) tablespace STOCK_TS04,
partition part_05 values less than(to_date('2011-01-01','yyyy-mm-dd')) tablespace STOCK_TS05,
partition part_06 values less than(to_date('2011-02-01','yyyy-mm-dd')) tablespace STOCK_TS06,
partition part_07 values less than(to_date('2011-03-01','yyyy-mm-dd')) tablespace STOCK_TS07,
partition part_08 values less than(to_date('2011-04-01','yyyy-mm-dd')) tablespace STOCK_TS08,
partition part_09 values less than(to_date('2011-05-01','yyyy-mm-dd')) tablespace STOCK_TS09,
partition part_10 values less than(to_date('2011-06-01','yyyy-mm-dd')) tablespace STOCK_TS10,
partition part_11 values less than(to_date('2011-07-01','yyyy-mm-dd')) tablespace STOCK_TS11,
partition part_12 values less than(to_date('2011-08-01','yyyy-mm-dd')) tablespace STOCK_TS12,
partition part_13 values less than(to_date('2011-09-01','yyyy-mm-dd')) tablespace STOCK_TS13,
partition part_14 values less than(to_date('2011-10-01','yyyy-mm-dd')) tablespace STOCK_TS14,
partition part_15 values less than(to_date('2011-11-01','yyyy-mm-dd')) tablespace STOCK_TS15,
partition part_16 values less than(to_date('2011-12-01','yyyy-mm-dd')) tablespace STOCK_TS16,
partition part_17 values less than(to_date('2012-01-01','yyyy-mm-dd')) tablespace STOCK_TS17,
partition part_18 values less than(to_date('2012-02-01','yyyy-mm-dd')) tablespace STOCK_TS18,
partition part_19 values less than(to_date('2012-03-01','yyyy-mm-dd')) tablespace STOCK_TS19,
partition part_20 values less than(to_date('2012-04-01','yyyy-mm-dd')) tablespace STOCK_TS20,
partition part_21 values less than(to_date('2012-05-01','yyyy-mm-dd')) tablespace STOCK_TS21,
partition part_22 values less than(to_date('2012-06-01','yyyy-mm-dd')) tablespace STOCK_TS22,
partition part_23 values less than(to_date('2012-07-01','yyyy-mm-dd')) tablespace STOCK_TS23,
partition part_24 values less than(to_date('2012-08-01','yyyy-mm-dd')) tablespace STOCK_TS24,
partition part_25 values less than(to_date('2012-09-01','yyyy-mm-dd')) tablespace STOCK_TS25,
partition part_26 values less than(to_date('2012-10-01','yyyy-mm-dd')) tablespace STOCK_TS26,
partition part_27 values less than(to_date('2012-11-01','yyyy-mm-dd')) tablespace STOCK_TS27,
partition part_28 values less than(to_date('2012-12-01','yyyy-mm-dd')) tablespace STOCK_TS28,
partition part_29 values less than(to_date('2013-01-01','yyyy-mm-dd')) tablespace STOCK_TS29,
partition part_30 values less than(to_date('2013-02-01','yyyy-mm-dd')) tablespace STOCK_TS30,
partition part_31 values less than(to_date('2013-03-01','yyyy-mm-dd')) tablespace STOCK_TS31,
partition part_32 values less than(to_date('2013-04-01','yyyy-mm-dd')) tablespace STOCK_TS32,
partition part_33 values less than(to_date('2013-05-01','yyyy-mm-dd')) tablespace STOCK_TS33,
partition part_34 values less than(to_date('2013-06-01','yyyy-mm-dd')) tablespace STOCK_TS34,
partition part_35 values less than(to_date('2013-07-01','yyyy-mm-dd')) tablespace STOCK_TS35,
partition part_36 values less than(to_date('2013-08-01','yyyy-mm-dd')) tablespace STOCK_TS36,
partition part_37 values less than(to_date('2013-09-01','yyyy-mm-dd')) tablespace STOCK_TS37,
partition part_38 values less than(to_date('2013-10-01','yyyy-mm-dd')) tablespace STOCK_TS38,
partition part_39 values less than(to_date('2013-11-01','yyyy-mm-dd')) tablespace STOCK_TS39,
partition part_40 values less than(to_date('2013-12-01','yyyy-mm-dd')) tablespace STOCK_TS40,
partition part_41 values less than(maxvalue) tablespace STOCK_TS41
);
CREATE INDEX IND_M_STOCK_RECORD_HOUSEID ON M_STOCK_RECORD
(HOUSE_ID, HOUSE_TYPE, GOODS_ID)
LOGGING
LOCAL (
PARTITION PART_01
LOGGING
NOCOMPRESS,
PARTITION PART_02
LOGGING
NOCOMPRESS,
PARTITION PART_03
LOGGING
NOCOMPRESS,
PARTITION PART_04
LOGGING
NOCOMPRESS,
PARTITION PART_05
LOGGING
NOCOMPRESS,
PARTITION PART_06
LOGGING
NOCOMPRESS,
PARTITION PART_07
LOGGING
NOCOMPRESS,
PARTITION PART_08
LOGGING
NOCOMPRESS,
PARTITION PART_09
LOGGING
NOCOMPRESS,
PARTITION PART_10
LOGGING
NOCOMPRESS,
PARTITION PART_11
LOGGING
NOCOMPRESS,
PARTITION PART_12
LOGGING
NOCOMPRESS,
PARTITION PART_13
LOGGING
NOCOMPRESS,
PARTITION PART_14
LOGGING
NOCOMPRESS,
PARTITION PART_15
LOGGING
NOCOMPRESS,
PARTITION PART_16
LOGGING
NOCOMPRESS,
PARTITION PART_17
LOGGING
NOCOMPRESS,
PARTITION PART_18
LOGGING
NOCOMPRESS,
PARTITION PART_19
LOGGING
NOCOMPRESS,
PARTITION PART_20
LOGGING
NOCOMPRESS,
PARTITION PART_21
LOGGING
NOCOMPRESS,
PARTITION PART_22
LOGGING
NOCOMPRESS,
PARTITION PART_23
LOGGING
NOCOMPRESS,
PARTITION PART_24
LOGGING
NOCOMPRESS,
PARTITION PART_25
LOGGING
NOCOMPRESS,
PARTITION PART_26
LOGGING
NOCOMPRESS,
PARTITION PART_27
LOGGING
NOCOMPRESS,
PARTITION PART_28
LOGGING
NOCOMPRESS,
PARTITION PART_29
LOGGING
NOCOMPRESS,
PARTITION PART_30
LOGGING
NOCOMPRESS,
PARTITION PART_31
LOGGING
NOCOMPRESS,
PARTITION PART_32
LOGGING
NOCOMPRESS,
PARTITION PART_33
LOGGING
NOCOMPRESS,
PARTITION PART_34
LOGGING
NOCOMPRESS,
PARTITION PART_35
LOGGING
NOCOMPRESS,
PARTITION PART_36
LOGGING
NOCOMPRESS,
PARTITION PART_37
LOGGING
NOCOMPRESS,
PARTITION PART_38
LOGGING
NOCOMPRESS,
PARTITION PART_39
LOGGING
NOCOMPRESS,
PARTITION PART_40
LOGGING
NOCOMPRESS,
PARTITION PART_41
LOGGING
NOCOMPRESS
)
NOPARALLEL;
CREATE INDEX IND_M_STOCK_RECORD_CODE ON M_STOCK_RECORD
(BAR_CODE)
NOLOGGING
NOPARALLEL;
CREATE INDEX M_STOCK_RECORD_ID2 ON M_STOCK_RECORD
(INOUT_ID)
LOGGING
NOPARALLEL;
CREATE INDEX M_STOCK_RECORD_IDX3 ON M_STOCK_RECORD
(SUBMIT_DATE, RECORD_ID)
LOGGING
NOPARALLEL;
CREATE INDEX M_STOCK_RECORD_ID5 ON M_STOCK_RECORD
(TO_CHAR("SUBMIT_DATE",'yyyy-mm-dd'))
NOLOGGING
NOPARALLEL;
CREATE INDEX M_STOCK_RECORD_IDX5 ON M_STOCK_RECORD
(TRUNC("SUBMIT_DATE"))
NOLOGGING
NOPARALLEL;
CREATE BITMAP INDEX IND_M_STOCK_RECORD_INOUTTYPE ON M_STOCK_RECORD
(INOUT_TYPE)
NOLOGGING
NOPARALLEL;
CREATE INDEX IND_M_STOCK_RECORD_HOUSE_TYPE ON M_STOCK_RECORD
(HOUSE_TYPE)
NOLOGGING
NOPARALLEL;
CREATE INDEX IND_M_STOCK_RECORD_HOUSEID ON M_STOCK_RECORD
(HOUSE_ID, HOUSE_TYPE, GOODS_ID)
NOLOGGING
NOPARALLEL;
comment on table M_STOCK_RECORD
is '库存流水表';
-- Add comments to the columns
comment on column M_STOCK_RECORD.RECORD_ID
is '流水ID';
comment on column M_STOCK_RECORD.HOUSE_ID
is '仓库ID';
comment on column M_STOCK_RECORD.BLOCK_ID
is '库区ID';
comment on column M_STOCK_RECORD.LOCATION_ID
is '库位ID';
comment on column M_STOCK_RECORD.BAR_CODE
is '商品条形码';
comment on column M_STOCK_RECORD.SUBMIT_USER_ID
is '操作人ID';
comment on column M_STOCK_RECORD.GOODS_ID
is '商品ID';
comment on column M_STOCK_RECORD.GOODS_AMOUNT
is '商品数量';
comment on column M_STOCK_RECORD.CHANGE_REASON
is '库存变化原因';
comment on column M_STOCK_RECORD.SUBMIT_DATE
is '库存变化日期';
comment on column M_STOCK_RECORD.OLD_STOCK_AMOUNT
is '上次库存数';
comment on column M_STOCK_RECORD.GOODS_TYPE
is '所属商品类别';
comment on column M_STOCK_RECORD.INOUT_TYPE
is '出入库类别';
comment on column M_STOCK_RECORD.INOUT_ID
is '操作来源ID';
comment on column M_STOCK_RECORD.HOUSE_TYPE
is '所属库类别';
comment on column M_STOCK_RECORD.VERSION
is '版本号';
comment on column M_STOCK_RECORD.GOODS_LINE
is '产品线';
comment on column M_STOCK_RECORD.SHEET_NO
is '单号';
insert /*+append*/ into m_stock_record_k select * from m_stock_record;
select max(record_id) from m_stock_record_bak partition (part_16);
insert /*+append*/ into m_stock_record select * from m_stock_record_bak where record_id>126682634754;
创建分区表之前，同样的sql语句查询需要40多秒，建了分区表之后查询只需要0.几秒，效率提高了几百倍。