Extend the node_promote_status index to include all fields required for the node page query.

Related topics

File

drupal-7.x/modules/node/node.install, line 555

Install, update and uninstall functions for the node module.

Code

function node_update_7002() {
  db_drop_index('node', 'node_promote_status');
  db_add_index('node', 'node_frontpage', array('promote', 'status', 'sticky', 'created'));
}