[wp-trac] [WordPress Trac] #24044: Add index to wp_options to aid/improve performance

[WordPress Trac]

#24044: Add index to wp_options to aid/improve performance
--------------------------------+--------------------------
 Reporter:  DanBUK              |       Owner:  pento
     Type:  defect (bug)        |      Status:  closed
 Priority:  normal              |   Milestone:  5.3
Component:  Options, Meta APIs  |     Version:
 Severity:  normal              |  Resolution:  fixed
 Keywords:  has-patch commit    |     Focuses:  performance
--------------------------------+--------------------------

Comment (by robinwilson16):

 @pento ok thank you for letting me know.
 Replying to [comment:83 pento]:
 > @robinwilson16: If they use the same index name, a warning will be
 generated when the DB upgrade happens (on single sites, when `wp-admin` is
 visited next, on multisites, when a network admin does the DB upgrade). If
 they have a different index name, MySQL will create the index, IIRC.
 Having a duplicate index is sub-optimal, but not a deal breaker.
 >
 > As a general rule, we don't try to handle compatibility with altered
 schemas during upgrades: if  you've changed the schema, you'll need to
 handle an incompatibilities caused.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/24044#comment:84>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform