•  
      request #46805 Simplify sql plan by replacing OR with UNION
    Infos
    #46805
    Nicolas Terray (nterray)
    2026-02-19 13:36
    2026-02-19 13:35
    48527
    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)
    Under implementation
    Empty
    Attachments
    Empty
    References
    References list is empty

    Follow-ups

    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)