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: Wiktor Moskwa <email@hidden>
- Date: Tue, 21 Aug 2007 20:47:04 +0200
- Organization: PowerMedia
Ken Anderson wrote:
> 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.
>
That means for 99% that statistics are not available.
Gather them and check the query plan again.
The other 1% percent is reserved for certain cases when optimizer
needs to be hinted or special indexes created.
If you post the statement and table/index DDL I'll be glad to help.
By not using bind variables every SQL statement will have to be hard
parsed every time it is send to the database. Hard parsing basically
means serializing access to some parts of database's shared memory.
--
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