Subject | Re: [firebird-support] Performance problem - input wanted |
---|---|
Author | setysvar |
Post date | 2017-11-17T20:48:53Z |
Just thought of a very simple test you could run, Michael. Is the plan
identical for the following query on the old and new server?
select *
from rdb$database
where not exists(
select v509Index
from VAREFRVSTR_DETAIL
where VarePlu_ID=:PVarePlu_ID and
Afdeling_ID=:AfdNr and
Farve_Navn=:PFarve_Navn and
Stoerrelse_Navn=:PStoerrelse_Navn and
Laengde_Navn=:PLaengde_Navn)
Set
identical for the following query on the old and new server?
select *
from rdb$database
where not exists(
select v509Index
from VAREFRVSTR_DETAIL
where VarePlu_ID=:PVarePlu_ID and
Afdeling_ID=:AfdNr and
Farve_Navn=:PFarve_Navn and
Stoerrelse_Navn=:PStoerrelse_Navn and
Laengde_Navn=:PLaengde_Navn)
Set