Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Poorly performing query and 10053 trace
Ups :)
On 1/12/06, Boris Dali wrote:
>
> 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
>
-- Jurijs +44 7738 013090 (GMT) ============================================ http://otn.oracle.com/ocm/jvelikanovs.html -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 13 2006 - 02:54:51 CST
![]() |
![]() |