I understand that data from real database are restricted.

But what is the query plan for my CTE?

Do you have an index on column id_parent?

I am really interested about it in your environment i use it every day.

Regards,