Re: Poorly performing query and 10053 trace

From: Boris Dali <boris_dali@xxxxxxxx>
To: j.velikanovs@xxxxxxxxx, kennaim@xxxxxxxxx
Date: Thu, 12 Jan 2006 19:48:37 -0500 (EST)

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 <j.velikanovs@xxxxxxxxx> 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

Follow-Ups:

Re: Poorly performing query and 10053 trace
From: Jurijs Velikanovs

Re: Poorly performing query and 10053 trace
From: Wolfgang Breitling

References:
- Re: Poorly performing query and 10053 trace
  - From: Jurijs Velikanovs

Re: Poorly performing query and 10053 trace

Other related posts: