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

Home -> Community -> Usenet -> c.d.o.server -> Re: CBO Subquery Limitations

Re: CBO Subquery Limitations

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Aug 2005 19:11:54 +0200
Message-ID: <78dkf1t7q3o1af0kmik4sre4b125pr6mjr@4ax.com>


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
Received on Wed Aug 10 2005 - 12:11:54 CDT

Original text of this message

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