May 13, 2013 at 3:57 pm
When I do an inner join of two tables: table 1 and table 2,
does the postion of the table matters ?
I mean on the left or right of the inner join, for example
below, do they make any difference?
table1 inner join table2
or
table2 inner join table1
May 13, 2013 at 4:26 pm
Doesn't matter
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 13, 2013 at 4:31 pm
It'll only matter if you start doing query hint overrides... which you should avoid in 99% of circumstances, so yeah... won't matter. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 4:41 pm
Thanks!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply