Re: Oracle 3.3.4 a performance dog?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 20 Feb 1999 21:07:26 -0000
Message-ID: <919545648.20873.0.nnrp-07.9e984b29@news.demon.co.uk>

Peter,

Could you expand on this briefly - Were IN lists converted to concatenated OR's or was it some other strategy that caused the problem.

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

> There were changes in the optimizer between these two releases
>that made selects that did a lot of in-list processing (select ... where
abc
>in (.....)) perform slower. The upside was that most sites noticed a
>performance improvement.
>
Received on Sat Feb 20 1999 - 15:07:26 CST