[SQL] WordPress index table postmeta

# description: creates indexes to speed up by a factor of 10+ complexe queries that use meta queries!
# instrcutions: execute each of these queries once on your database to create the indexes, change the "wp_" prefix if needed.
# downside: the index tables can use a lot of space, be sure to check on your database size.
# caution: the creation of these indexes can be super heavy, better try on a preproduction database before doing it live.
# also: using these indexes shouldn't prevent you from optimizing your queries as much as possible anyway ;)
CREATE INDEX idx_key_value ON wp_postmeta(meta_key, meta_value(10));
CREATE INDEX idx_postid_key ON wp_postmeta(post_id, meta_key);