Posted by Erland Sommarskog on 07/24/05 18:12

Greg D. Moore (Strider) (mooregr_deleteth1s@greenms.com) writes:
> Actually it's an outer join and using HASH or MERGE seems to work fine.

Inner or outer does not make any difference. Books Online:

Join hints, which are specified in a query's FROM clause, enforce a
join strategy between two tables. If a join hint is specified for any
two tables, the query optimizer automatically enforces the join order
for all joined tables in the query, based on the position of the ON
keywords.

--
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: How to check the last modifys in database
• Prev in forum: Re: Massive amoutns of Reading
• Thread view: Re: Massive amoutns of Reading

[Reply to this message]