Subject Re: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE
Author Gabor Boros
2018. 06. 04. 16:17 keltezéssel, liviuslivius
liviuslivius@... [firebird-support] írta:
> I understand that data from real database are restricted.
> But what is the query plan for my CTE?


A VIEW based on a VIEW then JOIN-ed with a VIEW which contains the CTE.
So the plan is complex.

> Do you have an index on column id_parent?


This field come from a COALESCE(FIELD1,FIELD2) and both fields have a FK.

Gabor