| Subject | Re: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE |
|---|---|
| Author | Gabor Boros |
| Post date | 2018-06-20T06:59:40Z |
2018. 06. 04. 16:17 keltezéssel, liviuslivius
liviuslivius@... [firebird-support] írta:
So the plan is complex.
Gabor
liviuslivius@... [firebird-support] írta:
> I understand that data from real database are restricted.A VIEW based on a VIEW then JOIN-ed with a VIEW which contains the CTE.
> But what is the query plan for my 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