Re: "start with" non using index

It helps, but it is not exactly what you need:

select t.mak_xx,t.nr_porz,level lvl from (select s.mak_xx,s.nr_porz,s.derv_mak_xx,s.derv_nr_porz,s.dervlvl from spacer_strona s,makieta m,makieta m2 where m2.xx=125414 and m.kiedy=m2.kiedy and s.mak_xx=m.xx) t start with t.mak_xx=125414 and t.nr_porz=0 connect by t.mak_xx = prior t.derv_mak_xx and t.nr_porz = prior t.derv_nr_porz and prior t.dervlvl=3 Received on Mon Dec 04 2006 - 09:23:24 CST