[wp-trac] [WordPress Trac] #19935: Redundant index in comment table schema

[WordPress Trac]

#19935: Redundant index in comment table schema
--------------------------+-------------------
 Reporter:  westi         |      Owner:  ryan
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  3.4
Component:  Database      |    Version:  3.3.1
 Severity:  normal        |   Keywords:  early
--------------------------+-------------------
 From and lost and buried :
 http://core.trac.wordpress.org/ticket/9642#comment:26

   A minor improvement for the comments table: the first index is redundant
 since it is a prefix of the second one. KEY comment_approved
 (comment_approved), KEY comment_approved_date_gmt
 (comment_approved,comment_date_gmt),

 props dbuser123

 We should do this in 3.4 seeing as we are already tweaking db schemas

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/19935>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software