Posted by Erland Sommarskog on 10/01/31 11:19

serge (sergea@nospam.ehmail.com) writes:
> 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.

For an inner join the order does not matter.

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

These are optimizer hints, and you should use them if you can get
good performance in any other way.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

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

[Reply to this message]