-
Kevin Falcone authored
When MySQL optimizes our UPDATE where id in (SELECT) it doesn't know that the tables are linked, so it ends up walking and examining lots and lots of rows. Including the ObjectType column means that mysql can easily examine 1 row using our existing ObjectCustomFieldValues2 index and update immediately. There is no longer a need to add upgrade specific indexes for OCFVs (the transaction indexes still improve performance).
3d212688