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

    I'm not sure how true that is... what about a self-join?
    Surely the speed of the joins is dependent on the columns being joined (i.e. key columns vs non key columns), whether those columns are indexed, up-to-date statistics, and a tiny little bit of data type (e.g. int or varchar).
    I wouldn't say row count is an indicator for performance