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

Hi.

 Just curious - what computer you are using?  I tried it on PC ( P3-450Mhz + 128M memory ) and it run with  sub-second response time.
 Is it possible you have a general performance problem with your  system?

 Michael.

In article <38c7a435.9997285_at_pchemmis>,
  bl_at_REMOVE_THIS_TO_GET_REAL_ADDRESS.hemmis.be (Bart Loosvelt) wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 09 2000 - 00:00:00 CST