--- "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 -----------------------------------------------------------------