Update sorting for tag-filtered public timeline: needs notice_tag_tag_created_notice_id_idx index added to notice_tag

1 files changed, 4 insertions, 0 deletions

diff --git a/db/096to097.sql b/db/096to097.sql
index 53f4e97c9..38e4e958b 100644
--- a/db/096to097.sql
+++ b/db/096to097.sql
@@ -1,3 +1,7 @@
 -- Add indexes for sorting changes in 0.9.7
+
 -- Allows sorting public timeline by timestamp efficiently
 alter table notice add index notice_created_id_is_local_idx (created,id,is_local);
+
+-- Allows sorting tag-filtered public timeline by timestamp efficiently
+alter table notice_tag add index notice_tag_tag_created_notice_id_idx (tag, created, notice_id);