[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):

 It's great news this is finally being added by default but what will
 happen if this index already exists as users have added it themselves?
 Will this part fail gracefully if they happened to name it using the same
 convention? If not then I guess two indexes would exist, not that this
 should cause any issues and it is certainly better having this in place.
 Hopefully it won't cause the entire upgrade to fail midway but maybe
 someone is able to test this?
 Running various instances of WordPress on my hosting servers I do expect
 to see a noticeable positive impact (assuming people are keeping up to
 date), especially on the larger/busier sites.

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