Re: 9.2.0.4 buffer (sort)

  • From: Paul Drake <discgolfdba@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 13 Jul 2004 08:53:16 -0700 (PDT)

--- "Gamble, Scott" <Scott.Gamble@xxxxxxxxxxxx> 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.

Pd
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: