Changes between Version 17 and Version 18 of QueryOptimization

Timestamp:

04/26/26 16:01:30 (6 days ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -32 +32 @@
 
 [attachment:Performer_Events_No_Index.csv]
+
+==== Со индекс:
+
+{{{
+
+-- indexes for linking performers with specific event occurrences (M:N relationship)
+CREATE INDEX idx_ehp_performer_id ON "Event_Happening_Performer"(performer_id);
+CREATE INDEX idx_ehp_happening_id ON "Event_Happening_Performer"(event_happening_id);
+
+-- index for optimizing event lookups within scheduled event happenings
+CREATE INDEX idx_event_happening_event_id ON "Event_Happening"(event_id);
+
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "Performer_Events";
+
+}}}
 
 === Анализа и оптимизација на `Venue_Layout`