#添加索引
|
CREATE INDEX idx_canal ON "HUGETEST".dyh_case_info(canal);
|
CREATE INDEX idx_case_ref ON "HUGETEST".dyh_case_info(case_ref);
|
CREATE INDEX idx_case_type ON "HUGETEST".dyh_case_info(case_type);
|
CREATE INDEX idx_area_road_village ON "HUGETEST".dyh_case_info(que_area, que_road, que_village);
|
CREATE INDEX idx_source ON "HUGETEST".dyh_case_info(source);
|
CREATE INDEX idx_input_unit_id ON "HUGETEST".dyh_case_info(input_unit_id);
|
CREATE INDEX idx_status ON "HUGETEST".dyh_case_info(status);
|
CREATE INDEX idx_process ON "HUGETEST".dyh_case_info(process);
|
|
CREATE INDEX idx_belong_unit_id ON "HUGETEST".dyh_case_info_unfold(belong_unit_id);
|
CREATE INDEX idx_mediate_unit_id ON "HUGETEST".dyh_case_info_unfold(mediate_unit_id);
|
CREATE INDEX idx_medi_result ON "HUGETEST".dyh_case_info_unfold(medi_result);
|
|
CREATE INDEX idx_unit_grade ON "HUGETEST".dyh_ct_unit(unit_grade);
|
CREATE INDEX idx_unit_type ON "HUGETEST".dyh_ct_unit(unit_type);
|
CREATE INDEX idx_area_road_village ON "HUGETEST".dyh_ct_unit(area, road, village);
|
