I will have to admit my ignorance on soft upgrade. Can you point me somewhere to understand what is involved in a soft upgrade and then I will be able to answer your question?
Mamta
On 11/11/05, Mike Matrigali <[EMAIL PROTECTED]> wrote:
In the case of soft upgrade (ie. the case where there are no changes
to the metadata.properties) will you be disabling the new optimizer
overrides?
Mamta Satoor wrote:
> Hi,
>
> The patch for optimizer overrides includes changes in
> metadata.properties. I think this change in metadata.properties is going
> to require some form of upgrade code so that the sql text stored in the
> systems tables can be replaced with new sql text which uses this new
> form of optimizer overrides.
>
> I wondered if anyone can give me some pointers on how to get started
> with upgrade code to achieve this. In the mean time, I will start
> looking into it too.
>
> thanks,
> Mamta
