Hi Josef,
Firebird 3 shows plan Natural for all procedures.
2.5 also sometimes shows Natural, sometimes - mix of plans of queries
inside the procedure.
So, you cannot apply this plan to the statement.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
On 22.06.2018 9:47, josef.gschwendt...@quattro-soft.de
[firebird-support] wrote:
Hi,
for a certain select-statement IB-Expert shows the plan below:
PLAN JOIN (PRO INDEX (RDB$FOREIGN218), SORT (SORT (SC_COSTS NATURAL)))
If I apend this plan to the statement I get the error below:
There is no alias or table named SC_COSTS at this scope level.
My problem is, that I don't find any name or alias that works within
this plan.
Does anybody know how to do this?
Regards,
Josef
