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: How do I tune 'star' outer join in ORA73?

Re: How do I tune 'star' outer join in ORA73?

From: Bart Loosvelt <bl_at_REMOVE_THIS_TO_GET_REAL_ADDRESS.hemmis.be>
Date: 2000/03/09
Message-ID: <38c7a435.9997285@pchemmis>#1/1 






On Wed, 08 Mar 2000 21:34:49 GMT, michael_bialik_at_my-deja.com wrote:


> Try using hint /*+ RULE */ or deleting statistics for ALL involved

> tables.




Indeed it is really much better now. The query runs in 3 sec. instead
of 17.  Thank you for your help Michael, I think the users will be
really pleased with this.



Best regards,


Bart
Received on Thu Mar 09 2000 - 00:00:00 CST












Original text of this message













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