Re: EXPLAIN PLAN madness!

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Thu, 15 Nov 2001 09:12:54 GMT
Message-ID: <3bf386f7.2150131@news>

In a sudden spasm of awareness,
Mark Townsend doodled thusly:

>Check the init.ora parameter differences between the two DB's - it looks
>like the production DB has been set up to favour hash joins.
>
>> How is it possible to generate a plan that doesn't reference a table
>> used in the query?
>
>Values can be obtained from an index ? I suspect this may be a side effect
>of the above
>

Bummer. Sorry, Mark. Replied before I read your through explanation.

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