Re: 9.2.0.4 buffer (sort)

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Tue, 13 Jul 2004 08:53:16 -0700 (PDT)
Message-ID: <20040713155316.1351.qmail@web20412.mail.yahoo.com>

"Gamble, Scott" <Scott.Gamble_at_cardinal.com> wrote:
> Platform HP Tru64 5.1b
> DB version 9.2.0.4
>
> During testing of 9.2.0.4 on a test database with
> full production data =
> (fully analyzed) I have a query critical to this
> application that is =
> performing slower in the 9.2.0.4 database.=20

"merge join cartesian" is the real clue here. chances are quite good that you have a join condition missing that could provide for a better access path if explicitly stated.

Please re-examine the tables in the statement and look for other joins or filtering conditions.

I did not see the statement in your posting.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 13 2004 - 10:50:34 CDT