Lack of composite indexes for meta tables

  • Why the wp_commentmeta table does not have a composite index (comment_id,meta_key) by default? I believe it’s the only useful index for that table, am I wrong?

    Instead, it has two strange indexes: (comment_id) and (meta_key). I don’t have an idea how to use them.

    The same thing about wp_postmeta.

  • The topic ‘Lack of composite indexes for meta tables’ is closed to new replies.