Changes between Version 21 and Version 22 of QueryOptimization

Timestamp:

04/26/26 16:14:46 (6 days ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -236 +236 @@
 [attachment:Event_Overall_Ratings_No_Index.csv]
 
+==== Со индекс:
+
+{{{
+
+-- composite index to speed up grouping and aggregate calculations (AVG, COUNT)
+CREATE INDEX idx_ehr_happening_id_rating ON "Event_Happening_Rating"(event_happening_id, rating);
+
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "Event_Overall_Ratings";
+
+}}}
+
 === Анализа и оптимизација на `Event_Financial_Summary`