_options table missing an index on autoload column

[DionDesigns]

wp-includes/options.php has the following line:

if ( !$alloptions_db = $wpdb->get_results( "SELECT option_name, option_value FROM $wpdb->options WHERE autoload = 'yes'" ) )

However, the "autoload" column is not indexed. This can lead to significant performance degradation if the _options table is large.

[ocean90]

Hello @DionDesigns, welcome to WordPress Trac!

Thanks for your report, we are already tracking this request in #24044.