Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL suggestion on table order inside a join ? RE: suggestion on table order inside a join ?

  • December 28, 2017 at 2:18 am

    #1973681

    vsamantha35 - Wednesday, December 27, 2017 9:02 PM

    Not sure where I read it and couldn't recollect, but I read that in the JOIN the table on the right should have less number of rows then the table on left, if so, it will improve the performance. How far is it true????

    This might be true when the data is only able to be accessed in heaps (where there are no indexes, or no usable indexes, as well as no Primary and Foreign Keys), however, in a well designed database this is unlikely to be the case.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk