Re: Forcing use of an index

On Thu, 17 Mar 2005 05:56:56 -0800, Bob P wrote:

> Nope CBO is out.
>
> Yes I can use HINTS but they don't seem to help but then I'm not real
> good with hints.

Funny thing, that. Seems like Hints aren't likely to help at all if you are not able to use the CBO. From the "Oracle9i Database Performance Tuning Guide and Reference", chapter 5, I note that

"Hints (except for the RULE hint) invoke the cost-based optimizer (CBO). If you have not gathered statistics, then defaults are used."

Also, a number of other features (such as partitioning, the various other index types, etc.) are not even considered unless you use CBO, as the RBO isn't even aware of the capabilities.

I'd personally use the environment as a basis for a cost improvement / TCO business case to have someone or something replaced. (Then again, I'm also willing to put my job on the line to fight stupidity.)

/FGB Received on Thu Mar 17 2005 - 08:14:07 CST