Changes between Version 20 and Version 21 of QueryOptimization

Timestamp:

04/26/26 16:12:58 (7 weeks ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -186 +186 @@
 [attachment:Event_User_Ratings_No_Index.csv]
 
+==== Со индекс:
+
+{{{
+
+-- index for linking ratings to event happenings
+CREATE INDEX idx_ehr_happening_id ON "Event_Happening_Rating"(event_happening_id);
+
+-- index for linking ratings to users
+CREATE INDEX idx_ehr_user_id ON "Event_Happening_Rating"(user_id);
+
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "Event_User_Ratings";
+
+}}}
+
 === Анализа и оптимизација на `Event_Overall_Ratings`