Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      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
    Display settings

    Follow-ups

    User avatar
    Nicolas Terray (nterray)2026-02-19 13:36
    • 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)