Re: Problems with OR in Oracle 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 04 Jan 2006 20:48:34 +0100
Message-ID: <ne9or1djvuk0erdspuq6vi2e77lalogc4n@4ax.com>

On Wed, 4 Jan 2006 13:12:27 -0500, "Dan Dubinsky" <sofia_at_salmonllc.com> wrote:

>It isn't just this query. Whenever I do an outer join with an OR in
>additional filter criteria the query runs really slow.

So run EXPLAIN PLAN on the query, and check the execution path
>
>Are there any issues with Oracle 8i optomizer, outer joins and ORs?
>
>Thanks

Apart from the fact, there is no such thing as the Oracle 8i optomizer, the only issue here is providing insufficient information from your end.
Which 'optomizer' are you using anyway?
Are statististics current?
Are you aware using an outer join usually heavily determines the choice of the driving table?

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Jan 04 2006 - 13:48:34 CST