Index the meta_key in the postmeta table

This is one of two ‘Power Tweaks’ which are a feature of WP-Optimize Premium. This power tweak works by ensuring the meta_key column in the WordPress postmeta table can be indexed.

While the meta_key column appears to be indexed by default, the use of utf8mb4 limits the indexing of columns to a maximum of 191 characters. The meta_key column is 256 characters long and so can not be indexed.

This power tweak changes the column size down to 191 characters where possible, allowing the column to be indexed which helps queries to run faster.

Posted in: Power tweaks