create table GUILTY_PERSON_INFO(
ID number(15,0) primary key,
VOL_ID number(15,0) not null references SPEC_VOL_INFO(ID),
DOC_NO varchar2(30),
INTERNAL_NO varchar2(30),
DEPT_NO number(4,0) not null,
CLASS_NO number(4,0) not null,
DOC_YEAR number(4,0) default -1 not null,
VOL_TYPE number(2,0) default -1 not null,
NAME varchar2(80) not null,
PY varchar2(200),
NICKNAME varchar2(80),
SEX number(1,0) default -1,
BIRTHDAY date,
NATIVE_PLACE varchar2(50),
NATION number(2,0) default -1,
EDUCATION number(2,0) default -1,
CHARACTOR varchar2(100),
ID_CARD_NO varchar2(20),
PHOTO blob,
PHOTO_FILE_NAME varchar2(250),
PHOTO2 blob,
PHOTO2_FILE_NAME varchar2(250),
PHOTO3 blob,
PHOTO3_FILE_NAME varchar2(250),
TYPE number(1,0) default -1,
ADDRESS varchar2(100),
DISTRICT varchar2(80),
LIVE_ADDRESS varchar2(100),
DUTY_UNIT varchar2(80),
SERVICE_ADDRESS varchar2(100),
REASON_FOR_PUN varchar2(80),
INFO_SUMMARY varchar2(1000),
PUNISH_TYPE varchar2(160),
TIMES_TERM varchar2(80),
EXE_TERM_FROM date,
EXE_TERM_TO date,
APPROVE_UNIT varchar2(80),
APPROVE_TIME date,
LAW_PAPER_FILE_PATH varchar2(250),
LAW_PAPER_FILE_NAME varchar2(250),
LAW_PAPER_FILE_EXT varchar2(10),
EXECUTE_UNIT varchar2(80),
REC_PERSON varchar2(50),
REC_TIME date,
SEQ_NO number(4,0) default -1 not null,
CASE_ID number(15,0) references CASE_INFO(ID),
constraint FK_GUILTY_CLASS foreign key(DEPT_NO, CLASS_NO) references CLASS_INFO(DEPT_NO, CLASS_NO)
);
对这样一个复杂多字段``还包括BLOB字段的表``该如何建立索引优化呢``小弟初学``望高手指点``
ID number(15,0) primary key,
VOL_ID number(15,0) not null references SPEC_VOL_INFO(ID),
DOC_NO varchar2(30),
INTERNAL_NO varchar2(30),
DEPT_NO number(4,0) not null,
CLASS_NO number(4,0) not null,
DOC_YEAR number(4,0) default -1 not null,
VOL_TYPE number(2,0) default -1 not null,
NAME varchar2(80) not null,
PY varchar2(200),
NICKNAME varchar2(80),
SEX number(1,0) default -1,
BIRTHDAY date,
NATIVE_PLACE varchar2(50),
NATION number(2,0) default -1,
EDUCATION number(2,0) default -1,
CHARACTOR varchar2(100),
ID_CARD_NO varchar2(20),
PHOTO blob,
PHOTO_FILE_NAME varchar2(250),
PHOTO2 blob,
PHOTO2_FILE_NAME varchar2(250),
PHOTO3 blob,
PHOTO3_FILE_NAME varchar2(250),
TYPE number(1,0) default -1,
ADDRESS varchar2(100),
DISTRICT varchar2(80),
LIVE_ADDRESS varchar2(100),
DUTY_UNIT varchar2(80),
SERVICE_ADDRESS varchar2(100),
REASON_FOR_PUN varchar2(80),
INFO_SUMMARY varchar2(1000),
PUNISH_TYPE varchar2(160),
TIMES_TERM varchar2(80),
EXE_TERM_FROM date,
EXE_TERM_TO date,
APPROVE_UNIT varchar2(80),
APPROVE_TIME date,
LAW_PAPER_FILE_PATH varchar2(250),
LAW_PAPER_FILE_NAME varchar2(250),
LAW_PAPER_FILE_EXT varchar2(10),
EXECUTE_UNIT varchar2(80),
REC_PERSON varchar2(50),
REC_TIME date,
SEQ_NO number(4,0) default -1 not null,
CASE_ID number(15,0) references CASE_INFO(ID),
constraint FK_GUILTY_CLASS foreign key(DEPT_NO, CLASS_NO) references CLASS_INFO(DEPT_NO, CLASS_NO)
);
对这样一个复杂多字段``还包括BLOB字段的表``该如何建立索引优化呢``小弟初学``望高手指点``
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货