RE: HINTS , how to add correctly

2001-03-16 Thread Koivu, Lisa
Title: RE: HINTS , how to add correctly Also, as our esteemed colleagues on this list have pointed out in the past, deleting statistics and then analyzing can make a difference as well. Don't ask why. Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite

RE: HINTS , how to add correctly

2001-03-16 Thread bruce . taneja
aleed" To: Multiple recipients of list ORACLE-L Waleed.Khedr[EMAIL PROTECTED] @FMR.COMcc: Sent by: Subject: RE: HINTS , how to add

RE: HINTS , how to add correctly

2001-03-16 Thread Miller, Jay
Are you sure you don't have the explain plans reversed? I don't recall ever seeing the Rule Based Optimizer choosing to do a sort/merge when a nested loops was possible. Jay Miller -Original Message- Sent: Thursday, March 15, 2001 6:20 PM To: Multiple recipients of list ORACLE-L My

RE: HINTS , how to add correctly

2001-03-15 Thread Khedr, Waleed
Did you update the statistics for these tables? -Original Message- Sent: Thursday, March 15, 2001 6:20 PM To: Multiple recipients of list ORACLE-L My query runs fine (5 sec) under rule based optimizer but takes 1.5 minutes for cost based.. Our company wants to use only cost based