Re: [firebird-support] Plan with stored procedure

2018-06-22 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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,

[firebird-support] Plan with stored procedure

2018-06-22 Thread josef.gschwendt...@quattro-soft.de [firebird-support]
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