•  
      request #46805 Simplify sql plan by replacing OR with UNION
    Infos
    #46805
    Nicolas Terray (nterray)
    2026-04-08 12:10
    2026-02-19 13:35
    48536
    Details
    Simplify sql plan by replacing OR with UNION

    Using OR in sql queries can force MySQL to perform a full scan which is not nice for performances.

    Trackers
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Nicolas Terray (nterray)
    Closed
    2026-04-08
    Attachments
    Empty
    References
    Referenced by request #46805

    Follow-ups

    User avatar
    Thomas Gerbet (tgerbet)2026-04-08 12:10

    Most impactful queries spotted in profiles have been treated. No need to keep the request open, we will do changes once we have meaningful information to prioritize the changes.


    • Status changed from Under implementation to Closed
    • Connected artifacts
    • Close date set to 2026-04-08
    User avatar
    • Summary
      -Simplify sql plan by replacing OR u 
      +Simplify sql plan by replacing OR with UNION 
    • Original Submission
      Something went wrong, the follow up content couldn't be loaded
      Only formatting have been changed, you should switch to markup to see the changes
    • Category set to Trackers
    • Status changed from New to Under implementation
    • Assigned to changed from None to Nicolas Terray (nterray)