Posted by David Portas on 10/01/44 11:19

> If I join Table1 to Table2 with a WHERE condition, is
> it the same if I would join Table2 to Table1 considering
> that the size of the tables are different.

Yes.

> I've never used MERGE, HASH JOINs etc, do any of
> these help in this scenario?

No.

--
David Portas
SQL Server MVP
--

"serge" <sergea@nospam.ehmail.com> wrote in message
news:7_%te.82758$Jk6.1151808@wagner.videotron.net...
> If I join Table1 to Table2 with a WHERE condition, is
> it the same if I would join Table2 to Table1 considering
> that the size of the tables are different.
>
> Let's assume Table2 is much bigger than Table1.
>
> I've never used MERGE, HASH JOINs etc, do any of
> these help in this scenario?
>
>
> Thank you
>

• Next in forum: Re: Join Small Table to Big Table or Vice Versa, does it matter?
• Prev in forum: Re: deadlocks involving parallelism
• Thread view: Re: Join Small Table to Big Table or Vice Versa, does it matter?

[Reply to this message]