//创建索引
CREATE INDEX idx_TB_GJ_BKSJBQK_2022 ON TB_GJ_BKSJBQK_2022(TASK_OBJECT_ID);
CREATE INDEX idx_TB_GJ_BKSJBQK_2022_XH ON TB_GJ_BKSJBQK_2022(XH);
CREATE INDEX idx_tb_gj_yjbkbysjyqk_2022 ON tb_gj_yjbkbysjyqk_2022(TASK_OBJECT_ID);
CREATE INDEX idx_tb_gj_yjbkbysjyqk_2022_XH ON tb_gj_yjbkbysjyqk_2022(XH);
CREATE INDEX idx_tb_gj_kkqk_2022 ON tb_gj_kkqk_2022(TASK_OBJECT_ID);
CREATE INDEX idx_tb_gj_kkqk_2022_KKH ON tb_gj_kkqk_2022(KKH);
CREATE INDEX idx_tb_gj_kkqk_2022_SKJSGH ON tb_gj_kkqk_2022(SKJSGH);
CREATE INDEX idx_tb_gj_fsyyszqk_2022 ON tb_gj_fsyyszqk_2022(TASK_OBJECT_ID);
CREATE INDEX idx_tb_gj_fsyyszqk_2022_GH ON tb_gj_fsyyszqk_2022(GH);
CREATE INDEX idx_tb_gj_wpjzjsjbxx_2022_GH ON tb_gj_wpjzjsjbxx_2022(GH);
//执行索引
analyze table TB_GJ_BKSJBQK_2022 compute statistics
analyze table tb_gj_yjbkbysjyqk_2022 compute statistics
analyze table tb_gj_kkqk_2022 compute statistics
analyze table tb_gj_fsyyszqk_2022 compute statistics
analyze table tb_gj_wpjzjsjbxx_2022 compute statistics
索引的创建以及执行生效
最新推荐文章于 2023-10-24 09:21:09 发布