Re: CBO Subquery Limitations

On 10 Aug 2005 05:26:28 -0700, mccmx_at_hotmail.com wrote:

>I'm currently administering a Peoplesoft HRMS application which makes
>heavy use of correlated subqueries (i.e. nearly every pice of SQL), and
>I'm finding that I have to hint nearly evey SQL statement to get the
>best plan. Overall the performance of the system is very poor because
>the optimizer is choosing a significantly inferior plan in 90% of the
>cases.

IIRC Peoplesoft is a so-called 'Database Agnostic' application, and requires RBO.

Apart from that Database Agnostic applications usually only support the Worst Common Denominator of versions supported.

--
Sybrand Bakker, Senior Oracle DBA