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

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.