Re: Hash Join

From: bullmkt123@my-deja.com > >We are doing a UPDATE with a sub-query on a large table. It is very >slow because its doing a nested loop join. I was under the impression >that 7.3 will do a hash-join on a sub-query. Is there a way to force it >to use the hash-join. Please post an example if you intend to use the >directives. No, but subqueries get flattened into joins. If you set OPTCOMPIND 2 in your onconfig file, you will encourage use of HASH JOINS. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com