Re: Question - dissimilar Plans in 'identical' environments

From: Joel Garry <joel-garry_at_home.com>
Date: 20 Jul 2005 17:13:15 -0700
Message-ID: <1121904795.444498.261270@g14g2000cwa.googlegroups.com>

>If there are stats for all the tables, CBO will be used

Shouldn't this be "If there are stats on _any_ of the tables, CBO will be used."?

You must check all tables involved to see if any have stats.

I used to think CHOOSE was a good thing for transitional systems, but after being burned enough times by this I decided, either RBO or not, no CHOOSE!

By the way, explain plan can lie (search for "plan lies" - with the quotes - at asktom.oracle.com). Trace to be sure.

--
@home.com is bogus.
And they called Carly "Chainsaw":
http://www.signonsandiego.com/uniontrib/20050720/news_1b20hp.html

Received on Wed Jul 20 2005 - 19:13:15 CDT