add_clean_index( string $table, string $index ): true

User Contributed Notes

1. Skip to note 2 content

   MakeWebBetter 6 years ago

   You must log in to vote on the helpfulness of this noteVote results for this note: 0You must log in to vote on the helpfulness of this note

   Sometimes after a table has been created in a database, we find that it is advantageous to add an index to that table to speed up queries involving this table.

   function wpdocs_mwb_make_fetch_fast()
   {
       global $wpdb;
       // Add some Clean up indices
       add_clean_index( $wpdb->posts, 'post_name' );
       add_clean_index( $wpdb->categories, 'category_nicename' );
       add_clean_index( $wpdb->comments, 'comment_approved' );
       add_clean_index( $wpdb->posts, 'post_status' );
   }