Posted by Karim on 09/25/65 11:19

On Tue, 21 Jun 2005 17:52:02 -0400, serge wrote:

> 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.

It doesn't matter because the query optimizer will go through thousands of
optimization iterations and choose the best plan it found so far in the
time frame it knows it should not spend any further.

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

no.. The query optimizer is smart enough to choose the best plan.


Tony
--
http://www.dotnet-hosting.com
Free web hosting with ASP.NET & SQL Server

• Next in forum: Re: MSSQL linked server to Oracle RDB
• Prev in forum: Re: 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]