Re: performance problems with hierarchical query and outer join

On Fri, 24 Mar 2006 09:46:53 +0100, Cris Carampa wrote:

> select
> mov0.*
> from
> FRN,
> MOV0
> where
> frn.all_cod(+) = mov0.all_cod and
> frn.lotto_entrata_id(+) = mov0.lotto_entrata_id
> start with
> ${some start condition on mov0}
> connect by
> ( mov0.all_cod = prior mov0.all_cod and mov0.zona_destinazione_id =
> prior mov0.zona_provenienza_id and mov0.box_destinazione_id = prior
> mov0.box_provenienza_id and mov0.fase_destinazione_dat_dal = prior
> mov0.fase_provenienza_dat_dal and mov0.movimento_data <= prior
> mov0.movimento_data )

May be, if you could put tables FRN and MOV in a cluster and cluster them on all_cod column?

-- 
http://www.mgogala.com