[wp-trac] [WordPress Trac] #33376: Create index on user_email and UNIQUE on user_nicename, user_email and user_login

[WordPress Trac]

#33376: Create index on user_email and UNIQUE on user_nicename, user_email and
user_login
------------------------------------+-----------------------------
 Reporter:  chriscct7               |       Owner:  chriscct7
     Type:  enhancement             |      Status:  assigned
 Priority:  normal                  |   Milestone:  Future Release
Component:  Database                |     Version:
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |     Focuses:  performance
------------------------------------+-----------------------------

Comment (by dd32):

 Unfortunately I feel the `UNIQUE` index is probably out of reach for us,
 and since we're already enforcing uniqueness at the application layer, a
 unique index vs non-unique index doesn't seem like the performance benefit
 would outweigh any compatibility issues.

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