[wp-trac] [WordPress Trac] #15004: Missing index on signups table

[WordPress Trac]

#15004: Missing index on signups table
------------------------------+------------------
 Reporter:  barry             |       Owner:
     Type:  defect (bug)      |      Status:  new
 Priority:  normal            |   Milestone:  3.5
Component:  Database          |     Version:
 Severity:  normal            |  Resolution:
 Keywords:  has-patch commit  |
------------------------------+------------------

Comment (by pento):

 `(user_login,user_email)` is a reasonable PK. I also noticed a query that
 was deleting by `(domain,path)`, so swapping the `domain` key for
 `domain_path` will improve that.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/15004#comment:11>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software