Changes between Version 2 and Version 3 of OtherTopics

Timestamp:

06/01/26 22:51:45 (2 weeks ago)

Author:

181201

Comment:

--

OtherTopics

@@ -80 +80 @@
 }}}
 
+(Note, for the exact same performance reasons, we also created to optimize the queries when Pet Owners view their own bookings)
+{{{
+#!sql
+CREATE INDEX idx_bookings_owner_date 
+ON project.bookings (owner_id, date_from DESC);
+}}}
+
 Execution with indexes:
 
@@ -100 +107 @@
 
 Because the execution time has been massively lowered by bypassing the expensive sequential scan and memory sort, we '''keep''' this index.
+
+*(Note: For the exact same performance reasons, we also created `CREATE INDEX idx_bookings_owner_date ON project.bookings (owner_id, date_from DESC);` to optimize the queries when Pet Owners view their own booking history).*
+
 
 == 2. Calculate average sitter rating ==