oracle大数据量表优化
我的当前表信息：
create table CARDB.CAR_ALL_INFO
(
  CAR_PASS_ID VARCHAR2(30) not null,
  CAR_NO VARCHAR2(16),
  PASS_TIME VARCHAR2(50),
  CROSS_ID VARCHAR2(16),
  ROAD_ID VARCHAR2(12),
  CAR_PATH_ID VARCHAR2(4),
  SPEED NUMBER(18,2),
  PLATECOLOR VARCHAR2(30),
  CAR_PIC_FILENAME1 VARCHAR2(300),
  CAR_PIC_FILENAME2 VARCHAR2(300),
  CAR_VIDEO_FILENAME VARCHAR2(300),
  ABSOLE_SHOW NUMBER(22),
  CAR_TYPE VARCHAR2(4),
  MATCHED NUMBER(22),
  OLD_PIC_FILENAME1 VARCHAR2(300),
  OLD_PIC_FILENAME2 VARCHAR2(300),
  OLD_VIDEO_FILENAME VARCHAR2(300),
  V_MONTH VARCHAR2(2),
  CLIENT_ID VARCHAR2(10),
  WZXW VARCHAR2(4)
)
partition by list (V_MONTH)
(
  partition CAR_ALL_INFO01 values ('01')
  tablespace epdbbp01
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
  initial 80K
  minextents 1
  maxextents unlimited
  ),
  partition CAR_ALL_INFO02 values ('02')
  tablespace epdbbp02
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
  initial 80K
  minextents 1
  maxextents unlimited
  ),
  partition CAR_ALL_INFO03 values ('03')
  tablespace epdbbp03
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
  initial 80K
  minextents 1
  maxextents unlimited
  ),
  partition CAR_ALL_INFO04 values ('04')
  tablespace epdbbp04
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
  initial 80K
  minextents 1
  maxextents unlimited
  ),
  partition CAR_ALL_INFO05 values ('05')
  tablespace epdbbp05
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
  initial 80K
  minextents 1
  maxextents unlimited
  ),
  partition CAR_ALL_INFO06 values ('06')
  tablespace epdbbp06
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
  initial 80K
  minextents 1
  maxextents unlimited
  ),
  partition CAR_ALL_INFO07 values ('07')
  tablespace epdbbp07
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
  initial 80K
  minextents 1
  maxextents unlimited
  ),
  partition CAR_ALL_INFO08 values ('08')
  tablespace epdbbp08
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
  initial 80K
  minextents 1
  maxextents unlimited
  ),
  partition CAR_ALL_INFO09 values ('09')
  tablespace epdbbp09
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
  initial 80K
  minextents 1
  maxextents unlimited
  ),
  partition CAR_ALL_INFO10 values ('10')