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
  • [fi... michael.vilhelm...@microcom.dk [firebird-support]
    • ... Рустам Муса-Ахунов rusta...@ukr.net [firebird-support]
      • ... Svein Erling Tysvær setys...@gmail.com [firebird-support]
    • ... Brian Dunstan br...@dunstan.biz [firebird-support]
      • ... michael.vilhelm...@microcom.dk [firebird-support]
    • ... setysvar setys...@gmail.com [firebird-support]
      • ... michael.vilhelm...@microcom.dk [firebird-support]
        • ... Svein Erling Tysvær setys...@gmail.com [firebird-support]
          • ... michael.vilhelm...@microcom.dk [firebird-support]
            • ... Svein Erling Tysvær setys...@gmail.com [firebird-support]
              • ... michael.vilhelm...@microcom.dk [firebird-support]

Reply via email to