From f4e5da604604308b9f754de7e863c180fcedd8c9 Mon Sep 17 00:00:00 2001
From: xusd <330628789@qq.com>
Date: Tue, 24 Jun 2025 21:03:12 +0800
Subject: [PATCH] fix:超时办件优化

---
 sql/20250620.sql |   17 +++++++++++++++++
 1 files changed, 17 insertions(+), 0 deletions(-)

diff --git a/sql/20250620.sql b/sql/20250620.sql
new file mode 100644
index 0000000..9a90e48
--- /dev/null
+++ b/sql/20250620.sql
@@ -0,0 +1,17 @@
+#添加索引
+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);

--
Gitblit v1.8.0