Re: EXPLAIN PLAN madness!

From: Mark Townsend <markbtownsend_at_home.com>
Date: Thu, 15 Nov 2001 04:02:15 GMT
Message-ID: <B8187E45.6C83%markbtownsend@home.com>

in article 3bf2ea7a.32307966_at_ausnews.austin.ibm.com, Ed Stevens at Ed_Stevens_at_nospam.noway.nohow wrote on 11/14/01 2:07 PM:

> How do I explain these wildly different plans?

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 Received on Wed Nov 14 2001 - 22:02:15 CST