| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: perplexing plan?
I agree with you Don that hints are not always warranted - yes, on a small dev system any execution plan is going to be out of whack anyway.
But avoiding them in general, I guess with performance problems hints have been the best quick fix, always. Fresh stats, sometimes. A missing index, sometimes. A correct hint 70% of the time rendered a query that screamed.
Just my .02
Lisa Koivu
Oracle Database Administrator and Terrible Perl Programmer
Fairfield Resorts, Inc.
954-935-4117
"The line ++@_[0] is a cute example of why nonprogrammers think Perl is obscure. Try showing that line to your grandmother and explaining that you write stuff like that for a living." -- Perl Black Book
-----Original Message-----
From: Don Granaman [SMTP:granaman_at_home.com] Sent: Friday, October 05, 2001 4:36 PM To: Multiple recipients of list ORACLE-LSubject: Re: perplexing plan? Received on Fri Oct 05 2001 - 15:14:40 CDT
 |
 |