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, 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

[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 I don't find any name or alias that works within this plan.
 

 Does anybody know how to do this?
 

 Regards,
 Josef