> I would first rule out the possibility that the change was not
> committed. Both DDL and gbak are transactional, so not having committed
> the table change would result in that change not being part of the gbak
> backup.
Thank you, Mark.
So, this is not usual and somehow I should be
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,
Hi,
I forgot to write that "SC_Costs" is a stored procedure.
Josef
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