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
aleed" To: Multiple recipients of list ORACLE-L
Waleed.Khedr[EMAIL PROTECTED]
@FMR.COMcc:
Sent by: Subject: RE: HINTS , how to add
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
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