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

This email sent to [EMAIL PROTECTED]

Reply via email to