Jan 12, 2005 #1 shaunk Programmer Joined Aug 20, 2001 Messages 402 Location AU I have read that the two following joins are identical: Table A Left Join Table B and Table B right join Table A They produce the same result set but are radically different in run times. Is there an efficiency difference between the two?
I have read that the two following joins are identical: Table A Left Join Table B and Table B right join Table A They produce the same result set but are radically different in run times. Is there an efficiency difference between the two?
Jan 12, 2005 #2 PHV MIS Joined Nov 8, 2002 Messages 53,708 Location FR but are radically different in run times And which is faster ? Upvote 0 Downvote
Jan 13, 2005 Thread starter #3 shaunk Programmer Joined Aug 20, 2001 Messages 402 Location AU The left join is faster by almost 30% as run from SQL Server Query Analyser. Upvote 0 Downvote