Re: Oracle8 and Outer join

From: Scott Donaldson <scott.donaldson_at_virgin.net>
Date: Tue, 9 Mar 1999 10:56:41 -0000
Message-ID: <7c2uo0$35p$1@nclient3-gui.server.virgin.net>

Philippe,

Have you checked differences in initialisation parameters between your databases (v$parameters table?). If you send execution profiles of the statement run on both platforms (using explain plan) to the group, this could help also. Otherwise it is difficult to guess.

Rgds
Scott

EFT.Philippe Lepot wrote in message ...
>Hi,
>
>We have a query with an outer join:
>
>SELECT DESCRIPTION FROM EVENT,ITEM WHERE EVENT.CASEENTITYID=:hCaseId AND
>
>EVENT.ITEMENTITYID=ITEM.ENTITYID(+);
>
>The above query runs fine on an Oracle 7.2, Oracle 8.0.5 Linux but is
>incredibly slow on an Oracle 8.0.5 NT. The databases are the same.
>Anyone has idea why?
>
>Thanks,
>
>Philippe.
>
Received on Tue Mar 09 1999 - 04:56:41 CST