Subject Re: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE
Author liviuslivius
Hi,

can you show some sample?
And what indexes have  you created?
Can you show plan for both queries and real queries itself?
What filter "where" are you using?

I am really interested because i have compared both queries with much more populated tables and i have got better results time, fetches and much bigger difference was memory usage.

Regards,
Karol Bieniaszewski