Re: poor performance after migration from 7.2.2 to 7.3.4.0.1

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 20 May 1999 08:49:56 +0100
Message-ID: <927187206.3593.1.nnrp-04.9e984b29@news.demon.co.uk>

I may have my version numbers mixed up, but wasn't it in the switch from 7.2 to 7.3 that the default value of the optimiser mode changed from RULE to CHOOSE ?

Try setting the value explicitly to RULE and see what happens.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

tedchyn_at_yahoo.com wrote in message <7hvmqr$v01$1_at_nnrp1.deja.com>...
>sigrid, did you update stat after migration ? do explain or sqltrace to
>find out what happen to your queries.
>
>Ted
>In article <7hsicb$h13$1_at_ernie.haupt.de>,
> Sigrid Staudte <sstaudte_at_sachsenlb.de> wrote:
>> Hi,
>>
>> after migration a database from version 7.2.2 to 7.3.4.0.1 the
>> execution of views are very slow. A view which select data from
>> several tables works fine. When I join this view with another view
>> or table for instance with a customer number then the performance is
>> very poor. I have changed the select statements in several ways
>without
>> success.
Received on Thu May 20 1999 - 02:49:56 CDT