Subject Re: [firebird-support] Re: Something IS seriously broken between 2.1.3 and 2.1.4
Author Wei Yu
OK. I changed the stored procedure a bit so now I can see the plans. the
only different:

under 2.1.3, Indexes used for INCIDENT: only IDX_INCIDENT_CLIENTID

under 2.1.4, Indexes used for INCIDENT: IDX_INCIDENT_CLIENTID and


> What is plan produced in 2.1.3 and 2.1.4
> if you can not get detailed plan when do
> select * from schedule_getclientlist('19', -1, 'Y', 'N');
> then try change this proc to execute block and get detailed plan
> and we will see where is different
> Karol Bieniaszewski

[Non-text portions of this message have been removed]