• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Poor Oracle performance? getting rid of bind variables
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Poor Oracle performance? getting rid of bind variables


  • Subject: Re: Poor Oracle performance? getting rid of bind variables
  • From: Wiktor Moskwa <email@hidden>
  • Date: Tue, 21 Aug 2007 20:25:17 +0200
  • Organization: PowerMedia

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

  • Follow-Ups:
    • Re: Poor Oracle performance? getting rid of bind variables
      • From: Ken Anderson <email@hidden>
References: 
 >Re: Poor Oracle performance? getting rid of bind variables (From: Ken Anderson <email@hidden>)

  • Prev by Date: Re: Poor Oracle performance? getting rid of bind variables
  • Next by Date: Re: Poor Oracle performance? getting rid of bind variables
  • Previous by thread: Re: Poor Oracle performance? getting rid of bind variables
  • Next by thread: Re: Poor Oracle performance? getting rid of bind variables
  • Index(es):
    • Date
    • Thread