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-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

    Artifact

    rel #47138 17.6
    Display settings

    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
    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)