Please consider these statements:

update or insert into "Transaction File" ("Store ID", "Unique
ID", "Quantity") values (1,47023,1) matching ("Store ID", "Unique ID")

and

update "Transaction File" set "Quantity"= 1 where "Store ID" =1
and "Unique ID"=47023

Statement Plan
--------------
PLAN (Transaction File INDEX (PK_TRANSACTION_FILE))


The first statment took over 200ms to execute the second only 16ms.
The record was present for both statements. I also executed these
statments several times with almost the same results ("update or
insert" being MUCH slower). "Store ID" and "Unique ID" is the primary
key.

I was expecting the performace results of these two statments to be
very close. Is this a bug, am i missing somthing, or is this the
expected results?

Thanks

Michael