| Subject | Re: [firebird-support] Plan with stored procedure |
|---|---|
| Author | Alexey Kovyazin |
| Post date | 2018-06-22T11:25:22Z |
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.Gschwendtner@... [firebird-support] wrote:
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.Gschwendtner@... [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