Re: Newbie help with explain plans

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 04 Sep 2003 00:52:53 GMT
Message-ID: <F1w5b.1604$dn4.1498@news02.roc.ny>

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:BXv5b.1601$1w4.1400_at_news02.roc.ny...
> His gut feeling could be right on spot. Fast query seems to be working on
> "no statistics" or using RBO.

:) I take my statement back
.. I did not look at the explain plan properly. It is using CBO in both cases.

Also .. "no statistics" also does not seem to be the case, since explain plan reports the cardinality in both cases.

So it seems either difference in way the tables are analyzed or different init.ora parameters.

Anurag Received on Wed Sep 03 2003 - 19:52:53 CDT