Comment by RenThraysk

Would be interesting to see the DDL of the table, to see if it had unique constraints.

The query not utilising an unique constraint/index should have raised a red flag.