Re: Poor Oracle performance? getting rid of bind variables
Re: Poor Oracle performance? getting rid of bind variables
- Subject: Re: Poor Oracle performance? getting rid of bind variables
- From: Ken Anderson <email@hidden>
- Date: Tue, 21 Aug 2007 14:35:52 -0400
Wiktor,
I'm killing my database now. I'm querying against a table that has
millions of rows, but I only need 20-30. With bind variables, it
takes over 20 seconds - without them, a few hundred milliseconds.
Ken
On Aug 21, 2007, at 2:25 PM, Wiktor Moskwa wrote:
Ken Anderson wrote:
Seems like other people have similar problems with bind variables:
http://www.thescripts.com/forum/thread65559.html
According to this guy, the optimizer punts when bind variables are
used
and uses a table scan! Now, more than anything, I really need to
figure
out how to stop EOF from using bind variables.
Any thoughts?
Thanks,
Ken
Don't do it or you will kill your database and application.
Here you will find explanation:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:
2444907911913
Cost Base Optimizer makes his decisions based on table, index
and column statistics (and few other things). Make sure at first that
they are available.
What is the exact statement that is inefficient in your case?
(provide DDL too so a necessary small test environment can be
established)
--
Wiktor Moskwa
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden