From f1fe397df175a7ee809ea28530419116af84af28 Mon Sep 17 00:00:00 2001
From: dengzedong <dengzedong@email>
Date: 星期二, 31 十二月 2024 17:32:45 +0800
Subject: [PATCH] t_mm_item_result 索引优化
---
iailab-module-model/iailab-module-model-biz/db/mysql.sql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/iailab-module-model/iailab-module-model-biz/db/mysql.sql b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
index d317c33..9ca9439 100644
--- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql
+++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
@@ -47,8 +47,8 @@
datatime datetime,
datavalue decimal(19, 3),
primary key (id),
- INDEX idx_outputid (outputid),
- INDEX idx_datatime (datatime)
+ UNIQUE KEY `unique_outputid_datatime` (`outputid`,`datatime`),
+ KEY `idx_outputid_datatime` (`outputid`,`datatime`) USING BTREE
) engine = innodb
default character set utf8mb4 COMMENT = '预测结果表';
--
Gitblit v1.9.3