Add additional indexes to database

Suggestions for more index tables. There is also possibility to add for different columns some suggested below.

Would also prefer to be able to select which one to create as users and usersmeta is not needed for sites with 2 users. Some other columns could be very helpful to boost performance for Woo while some is not needed if not a WooCommerce. Terms, relationships and taxonomy might not be useful if you don’t use etc.

But some core are missing, wp_posts, wp_posts with guid column, some plugins and themes are still querying with LIKE and have to scan the whole table to find.

This should be fairly quick to add maybe possible to add in a patch before the big update.

Maybe possible to hit or schedule optimize/analyse the different tables as well would be useful to regenerate all data?

wp_users
wp_terms
wp_posts
wp_posts => latest_posts
wp_posts => sitemaps
wp_posts => guid
wp_usermeta
wp_term_relationships
wp_term_taxonomy

Once detecting Redis perhaps run following to clean transients which should be loaded via redis.
delete from wp_options where autoload = 'yes' and option_name like '_transient%';