From fd03e31f173ad9c52b15a30a9127e2b6a468538d Mon Sep 17 00:00:00 2001
From: shikeying <shikeying@163.com>
Date: 星期一, 26 九月 2022 18:50:33 +0800
Subject: [PATCH] 视频相似度分析2
---
recommend-video/doc/table.SQL | 10 +++++++++-
1 files changed, 9 insertions(+), 1 deletions(-)
diff --git a/recommend-video/doc/table.SQL b/recommend-video/doc/table.SQL
index 2283614..5edc014 100644
--- a/recommend-video/doc/table.SQL
+++ b/recommend-video/doc/table.SQL
@@ -6,4 +6,12 @@
ADD INDEX inx_src_vid (src_video_id) USING BTREE ;
ALTER TABLE rc_video_t2
- ADD INDEX inx_t2_src_vid (src_video_id) USING BTREE ;
\ No newline at end of file
+ ADD INDEX inx_t2_src_vid (src_video_id) USING BTREE ;
+ALTER TABLE rc_video_t2
+ ADD INDEX inx_t2_src_bid (batch_id) USING BTREE ;
+
+-- ALTER TABLE rc_video_batch
+-- ADD INDEX inx_vb_vid (src_video_id) USING BTREE ;
+
+ALTER TABLE rc_video_batch
+ ADD INDEX inx_vb_bid (batch_id) USING BTREE ;
\ No newline at end of file
--
Gitblit v1.9.1