Re: Poorly performing query and 10053 trace

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: 2006-01-13 01:48:37
Message-id: 20060113004837.99831.qmail@web32811.mail.mud.yahoo.com

Wasn't it the opposite - if at least one table analyzed in a join, than the cbo kicks in and made-up stats used for non-analyzed tables?

Thanks,
Boris Dali.

• Jurijs Velikanovs wrote:

> >> this query accesses 2 analyzed tables
> >> and 3 unanalyzed tables
> If I recall correctly in 817 if some of the tables
> have no statistics
> Oracle uses RULE based optimizer.
> For RULE based optimizer the order in which indexes
> have been created
> some times play trumendios role.
> Can you confirm the that query parsed in the RULE
> mode?
>
> Jurijs
                                  

---

Find your next car at http://autos.yahoo.ca

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 13 2006 - 01:48:37 CST