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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
