Changes between Version 33 and Version 34 of QueryOptimization

Timestamp:

05/09/26 20:54:17 (3 weeks ago)

Author:

231027

Comment:

--

QueryOptimization

@@ -243 +243 @@
 ==== Оптимизација:
 
+{{{
+
+-- index for optimizing chronological filtering of future events
+CREATE INDEX idx_event_happening_time ON "Event_Happening"(event_time);
+
+-- index for accelerating lookups of events scheduled at specific venues
+CREATE INDEX idx_event_happening_venue_id ON "Event_Happening"(venue_id);
+
+-- composite index to optimize queries filtering both by venue and upcoming time slots
+CREATE INDEX idx_event_happening_venue_time ON "Event_Happening"(venue_id, event_time);
+
+}}}
+
 == Анализа и оптимизација на `Available_Tickets`
 
@@ -271 +284 @@
 ==== Оптимизација:
 
-
-== Документација за оптимизацијата на погледите
-
- * [attachment:"Оптимизација на прашалници.pdf"]
+{{{
+
+-- partial index for rapid retrieval of only unsold tickets by filtering out sold ones
+CREATE INDEX idx_ticket_is_available_true ON "Ticket"(is_available) WHERE is_available = TRUE;
+
+-- index for linking tickets to scheduled events to accelerate event-based filtering
+CREATE INDEX idx_ticket_event_happening_id ON "Ticket"(event_happening_id);
+
+-- index for optimizing seat-based joins to retrieve venue layout details for each ticket
+CREATE INDEX idx_ticket_seat_id ON "Ticket"(seat_id);
+
+}}}