Changes between Version 6 and Version 7 of P9

Timestamp:

05/25/26 21:38:25 (16 hours ago)

Author:

211099

Comment:

--

P9

@@ -405 +405 @@
 == Scenario 2 - Annual genre popularity and engagement trend
 
-== Without index analysis
+=== Without index analysis
 {{{
 |QUERY PLAN                                                                                                                                                                                                                                   |
@@ -479 +479 @@
 |Execution Time: 26.272 ms                                                                                                                                                                                                                    |
 }}}
-
+== Indexes for this queries
+{{{
+CREATE INDEX idx_has_genre_genre_id
+    ON has_genre(genre_id);
+
+CREATE INDEX idx_has_genre_story_id
+    ON has_genre(story_id);
+
+CREATE INDEX idx_status_story_published
+    ON status(story_id)
+    WHERE status = 'published';
+}}}