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 22:07:55 +0200
- Organization: PowerMedia
Ken Anderson wrote:
> According to the DBA, we're using the Rule Based Optimizer, not the Cost
> Based Optimizer, so therefore, no statistics.
Well, RBO is deprecated in 10g and CBO is far superior to it.
It's completely off-topic but I can't understand why one could prefer
RBO to CBO, which is around since release 7.
You didn't say which version do you use, I suspect it can be quite old.
> They claim there are indexes in on the table, but running a query
> against user_indexes returns 0 rows.
Be sure that you query while logged as user that owns this table and
table name is spelled correctly.
> Unfortunately, their contention is that I must be crazy, and are not
> paying much attention to me. There aren't any other WO developers here,
> so they are not very helpful when I tell them that I can do queries
> without bind variables.
Ok we've defined the problem - it's communication, not technology...
--
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