Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Does an upgrade of the db version affect index organization or number of entries returned from an index in a query?

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

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Thu, 10 May 2007 11:36:14 -0500
Message-ID: <de807caa0705100936if53ef2uf53ba7a2475cfbe3@mail.gmail.com> 





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


Received on Thu May 10 2007 - 11:36:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US