Changes between Version 22 and Version 23 of QueryOptimization

Timestamp:

04/26/26 16:17:33 (6 days ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -290 +290 @@
 
 [attachment:Event_Financial_Summary_No_Index.csv]
+
+==== Со индекс:
+
+{{{
+
+-- index for linking ticket purchases to the specific tickets
+CREATE INDEX idx_ticket_purchase_ticket_id ON "Ticket_Purchase"(ticket_id);
+
+-- index for the LEFT JOIN with refunds to calculate net revenue accurately
+CREATE INDEX idx_ticket_refund_purchase_id ON "Ticket_Refund"(purchase_id);
+
+-- index for linking tickets to scheduled events
+CREATE INDEX idx_ticket_event_happening_id ON "Ticket"(event_happening_id);
+
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "Event_Financial_Summary";
+
+}}}