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.
