• Kevin Falcone's avatar
    Improve our Dependent Subclause · 3d212688
    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).