After some testing, the "brutal" DISTINCT after the CONNECT-BY proved to be the fastest solution.
Thanks for all the suggestions. -- Riku Räsänen Kantamestarit OY riku.rasanen@xxxxxxxxxxxxxxxx +358 (0)50 548 0589 -- //www.freelists.org/webpage/oracle-l