Changes between Version 19 and Version 20 of QueryOptimization

Timestamp:

04/26/26 16:10:19 (6 days ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -131 +131 @@
 
 [attachment:User_Tickets_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 linking purchases to users
+CREATE INDEX idx_ticket_purchase_user_id ON "Ticket_Purchase"(user_id);
+
+-- index for the LEFT JOIN with refunds
+CREATE INDEX idx_ticket_refund_purchase_id ON "Ticket_Refund"(purchase_id);
+
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "User_Tickets";
+
+}}}
 
 === Анализа и оптимизација на `Event_User_Ratings`