Extend the node_promote_status index to include all fields required for the node page query.
function node_update_7002() {
db_drop_index('node', 'node_promote_status');
db_add_index('node', 'node_frontpage', array(
'promote',
'status',
'sticky',
'created',
));
}