Changes between Version 18 and Version 19 of QueryOptimization

Timestamp:

04/26/26 16:04:08 (6 days ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -81 +81 @@
 
 [attachment:Venue_Layout_No_Index.csv]
+
+==== Со индекс:
+
+{{{
+
+-- index for linking seats to their respective sections
+CREATE INDEX idx_seat_section_id ON "Seat"(section_id);
+
+-- index for linking sections to venues
+CREATE INDEX idx_section_venue_id ON "Section"(venue_id);
+
+
+EXPLAIN ANALYZE
+    SELECT *
+    FROM "Venue_Layout";
+
+}}}
 
 === Анализа и оптимизација на `User_Tickets`