[wp-trac] [WordPress Trac] #62790: "autoload" index is not used

[WordPress Trac]

#62790: "autoload" index is not used
--------------------------+--------------------------
 Reporter:  kkmuffme      |       Owner:  joemcgill
     Type:  defect (bug)  |      Status:  reviewing
 Priority:  normal        |   Milestone:  6.8
Component:  Database      |     Version:  5.3
 Severity:  minor         |  Resolution:
 Keywords:  needs-patch   |     Focuses:  performance
--------------------------+--------------------------

Comment (by joemcgill):

 After doing a bit more testing, I am not seeing a huge performance benefit
 from removing the index either. Given that the IN clause is now generated
 from `wp_autoload_values_to_autoload()` since [57920], and that value can
 be filtered to produce a more narrow IN clause where the index could still
 apply, it may be worth retaining the index for folks who are still able to
 make use of the benefit unless the performance gains from removing the
 index are worthwhile.

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