I am working on getting our database servers working as efficiently as possible and I keep running into cases where I need to add this:
alter table wp_posts add index post_status_post_date(post_status,post_date);
After setting this enough times it seems like it would be good to have it as a default and was hoping that was something you would take care of for us (we have a ton of WP installs here at the hosting company I work for ;-).