Changes between Version 7 and Version 8 of QueryOptimization

Timestamp:

04/26/26 15:23:00 (6 days ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -25 +25 @@
 EXPLAIN ANALYZE
     SELECT *
-    FROM "Event_Financial_Summary";
+    FROM "Performer_Events";
 
 }}}
@@ -46 +46 @@
 }}}
 
+==== Без индекс:
+
+{{{
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "Venue_Layout";
+
+}}}
+
 === `User_Tickets`
 
@@ -62 +72 @@
 JOIN "Ticket" t ON tp.ticket_id = t.ticket_id
 LEFT JOIN "Ticket_Refund" tr ON tp.purchase_id = tr.purchase_id;
+
+}}}
+
+==== Без индекс:
+
+{{{
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "User_Tickets";
 
 }}}
@@ -85 +105 @@
 }}}
 
+==== Без индекс:
+
+{{{
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "Event_User_Ratings";
+
+}}}
+
 === `Event_Overall_Ratings`
 
@@ -101 +131 @@
 JOIN "Event_Happening_Rating" ehr ON eh.event_happening_id = ehr.event_happening_id
 GROUP BY e.event_id, e.name, eh.event_happening_id, eh.event_time;
+
+}}}
+
+==== Без индекс:
+
+{{{
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "Event_Overall_Ratings";
 
 }}}
@@ -130 +170 @@
 
 }}}
+
+==== Без индекс:
+
+{{{
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "Event_Financial_Summary";
+
+}}}