Re: Does an upgrade of the db version affect index organization or number of entries returned from an index in a query?

Oh, I'm sure the CBO changed alrighty, I have bunches of queries that got mugged. My question was about factual issues:

Does the upgrade from one version of the db to another touch indexes, or other objects, outside the data dictionary? and
Can index organization affect the number of entries used in a query execution plan.

I think Oracle is telling me stories.

Allan

On 5/10/07, Dennis Williams <oracledba.williams_at_gmail.com> wrote:
>
> Allan,
>
> I think somebody on this list mentioned that there was a change in the CBO
> code between those two Oracle versions. I don't recall any other details.
> You could look at the bug fixes for 9.2.0.8 for hints. That seems like the
> logical explanation to me. Other than that, if the indexes are small, it
> couldn't hurt to rebuild them just to be confident.
>
> Dennis Williams
>

--
http://www.freelists.org/webpage/oracle-l