• 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: Guido Neitzer <email@hidden>
  • Date: Wed, 22 Aug 2007 09:34:59 -0600

On 22.08.2007, at 07:06, Mike Schrag wrote:

Yes, this is REEEALLY important, as you found. It's the same with Postgresql, too,

Yeah, but there it is really easy to get it to update statistics automatically with autovacuum which works really well if it is correctly set up. Not sure about Oracle but as far as I know, there is a similar thing to autovacuum that looks at how many changes were done and updates the statistics accordingly.


cug
_______________________________________________
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: Pascal Robert <email@hidden>
References: 
 >Re: Poor Oracle performance? getting rid of bind variables (From: Ken Anderson <email@hidden>)
 >Re: Poor Oracle performance? getting rid of bind variables (From: Wiktor Moskwa <email@hidden>)
 >Re: Poor Oracle performance? getting rid of bind variables (From: Ken Anderson <email@hidden>)
 >Re: Poor Oracle performance? getting rid of bind variables (From: Wiktor Moskwa <email@hidden>)
 >Re: Poor Oracle performance? getting rid of bind variables (From: Guido Neitzer <email@hidden>)
 >Re: Poor Oracle performance? getting rid of bind variables (From: Wiktor Moskwa <email@hidden>)
 >Re: Poor Oracle performance? getting rid of bind variables (From: Ken Anderson <email@hidden>)
 >Re: Poor Oracle performance? getting rid of bind variables (From: Wiktor Moskwa <email@hidden>)
 >Re: Poor Oracle performance? getting rid of bind variables (From: Pascal Robert <email@hidden>)
 >Re: Poor Oracle performance? getting rid of bind variables (From: Mike Schrag <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