>If your table is properly ordered then you should use 'scan while'
>rather then 'scan for' in order to scan trough hieararchy with one skip back
>any time one nested scan finishes.

Thanks, I'll take a look at that approach.