Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Messy SQL performance question (NOT in SELECT clause)

Re: Messy SQL performance question (NOT in SELECT clause)

From: Mick <theryans_at_rapidnet.net.au>
Date: 16 Apr 98 09:21:58 GMT
Message-ID: <01bd691f$838e84e0$0c14a8c0@hercules> 





If you are using a not in with a sub query, then try the HASH_AJ hint. This
will do some nice stuff and convert your not in to an inline view.
Alternatively you could do it as an inline view yourself and hand tune from
there.



Regards,


Michael Ryan


Received on Thu Apr 16 1998 - 04:21:58 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US