Changes between Version 5 and Version 6 of OtherTopics


Ignore:
Timestamp:
06/02/26 10:26:30 (3 weeks ago)
Author:
181201
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • OtherTopics

    v5 v6  
    106106'''Average execution time (10 attempts):''' 0.087ms
    107107
    108 Because the execution time has been massively lowered by bypassing the expensive sequential scan and memory sort, we '''keep''' this index.
    109 
    110 *(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).*
     108Because the execution time has been massively lowered by bypassing the expensive sequential scan and memory sort, we '''keep''' this index
    111109
    112110