View Single Post

Thread: SQL: RIGHT or LEFT JOIN more efficient

  1. - Top - End - #5
    Ogre in the Playground
     
    Imp

    Join Date
    Jul 2008
    Location
    Sweden
    Gender
    Male

    Default Re: SQL: RIGHT or LEFT JOIN more efficient

    Outer left and outer right are exactly the same. Inner join is slightly faster because it does slightly less work.
    The top answer on stack overflow goes into more detail.

    When you're dealing with legacy data and data structures that has gone through several generations it gets too complicated for me. I can offer no advice
    Last edited by Mastikator; 2021-03-08 at 01:05 PM.
    Black text is for sarcasm, also sincerity. You'll just have to read between the lines and infer from context like an animal