[wp-trac] [WordPress Trac] #33376: Create index on user_email

[WordPress Trac]

#33376: Create index on user_email
------------------------------+--------------------------
 Reporter:  chriscct7         |       Owner:  chriscct7
     Type:  enhancement       |      Status:  closed
 Priority:  normal            |   Milestone:  4.5
Component:  Database          |     Version:
 Severity:  normal            |  Resolution:  fixed
 Keywords:  has-patch commit  |     Focuses:  performance
------------------------------+--------------------------
Changes (by ocean90):

 * status:  assigned => closed
 * resolution:   => fixed


Comment:

 In [changeset:"36654"]:
 {{{
 #!CommitTicketReference repository="" revision="36654"
 Schema: Add an index to `wp_users.user_email`.

 Improves lookup of an email address on large user tables.

 See #9568.
 Fixes #33376.
 }}}

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