Re: EXPLAIN PLAN madness!

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Thu, 15 Nov 2001 09:11:53 GMT
Message-ID: <3bf3864c.1979457@news>

In a sudden spasm of awareness,
Ed Stevens doodled thusly:

>Subject: EXPLAIN PLAN madness!
>
>Platform: Oracle 8.0.5 SE, NT 4

Hmmmm time to upgrade, mayhap?

>
>So now I have two questions:
>
>How do I explain these wildly different plans?

Different init.ora parameters that favour hash joins in production.

>
>How is it possible to generate a plan that doesn't reference a table
>used in the query?
>

Because it might be reading an index of that table instead of the table itself? Quite common on joins to lookup tables.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Nov 15 2001 - 03:11:53 CST