Changes between Initial Version and Version 1 of Ticket #34811, comment 2


Ignore:
Timestamp:
Sep 2, 2023, 9:00:09 PM (13 months ago)
Author:
Simon Charette

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #34811, comment 2

    initial v1  
    1 If that can be of any help, we've observed that MySQL's query planer is can be pretty bad at using composite indexes when `OR` conditions are involved and had to resort to using `UNION` to target them.
     1If that can be of any help, we've observed that MySQL's query planer can be pretty bad at using composite indexes when `OR` conditions are involved and had to resort to using `UNION` to target them.
    22
    33Re-writing your lookup to move the `filling_id=pk` outside of the `OR` should help MySQL at figuring out that the `filing_id` index can be used at least.
Back to Top