How to create index (sql) to a meta_key?

I’m not going to tell you about what will happen. I’ll here give you an example on how you can run that piece of sql without phpMyadmin. Add this to your functions.php for temporary purpose. Not to forget about removing this after one run of your website.

$mymeta="_my_first_meta";
$wpdb->query(
   $wpdb->prepare("CREATE INDEX wp_postmeta_my_first_meta ON wp_postmeta (%s)",$mymeta)
);

Don’t forget to replace your Database Prefix with “wp_“

Related Posts:

  1. Inserting Post Meta From SQL
  2. How to execute mulitple statement SQL queries using $wpdb->query?
  3. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  4. Query WordPress database by registered date and role
  5. Size article thumbnails and retrieve them directly from database
  6. wpdb_prepare with multiple or condition
  7. SQL Error wp_commentmeta – incorrect table definition
  8. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  9. How do I get the posts within a certain year/date(with sql query)?
  10. Create table from array with prepare
  11. Why this query is not showing any result on wordpresss home page?
  12. Why does changing Database Table Prefixes result in loss of content?
  13. SQL query to set posts in bulk based on the post content
  14. $wpdb->get_var – What value is returned when zero records are found?
  15. DB prefix not updating
  16. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  17. Delete all users meta that named: user_avatar
  18. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  19. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  20. export individual posts to text files or a single csv file
  21. SQL query : Select a thumbnail for a media
  22. why you don’t Implement PDO for access every thing to database
  23. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  24. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  25. Case statement in MySQL
  26. Oracle SQL query for Date format
  27. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  28. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  29. Using wpdb to connect to a separate database
  30. WPDB Insert or if exists Update
  31. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  32. wpdb->insert multiple record at once
  33. How to define composite keys with dbDelta()
  34. WordPress for a very large website
  35. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  36. How to Join two tables from separate databases within WordPress
  37. Change SQL get_results to search for posts with custom term in custom taxonomy
  38. Error establishing a database connection – with Debug Data
  39. wpdb query on custom table not working [closed]
  40. Database with mixed collation (utf8mb4 & utf8_general_ci)
  41. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  42. Using table lock with wp_insert_post?
  43. Set Display Name to first and last name (phpmyadmin SQL Query)
  44. Is it safe to convert tables from MyISAM to InnoDB?
  45. Migrating database / content of non-CMS site to WordPress
  46. Does WordPress ever need multiple databases?
  47. Why are no posts showing despite my apparently correct DB restoration?
  48. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  49. Delete all post meta except featured image Using SQL
  50. How do I properly update the WordPress database password?
  51. Adding new row to wp_post table
  52. How do I find which articles are missing a featured image in The WordPress database?
  53. WordPress Install and Database on separate hosting?
  54. WordPress database error – Error in SQL syntax – I can’t identify any error?
  55. Database Tables Lost Indexes? How to Recover?
  56. Setup private content for specific users with daily updates [closed]
  57. Migration: Copying database content to a different server
  58. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  59. Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
  60. Duplicated site isn’t recognized as a site
  61. Query multiple tables at once?
  62. Have working sql query… trying to adjust it to use $wpdb
  63. Changing root password in PHPMyAdmin for WordPress Database when going live
  64. creating new field on mysql
  65. Remove empty rows from the database
  66. Custom WordPress Table wpdb
  67. how to encyrpt DB_PASSWORD in wp-config
  68. How can I detect right db type?
  69. Delete all posts that do NOT have a specific tag
  70. Changing order of db results when encoding to JSON
  71. Second ezSQL initialization for MSSQL
  72. Fetch a single row from a custom table for to a given ID
  73. Database create or redirect
  74. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  75. Link multiple user databases together?
  76. Sql query to get all metadata for a post
  77. Recovery – Restore Database after moving folder location locally
  78. Performing CRUD operations on front end in wordpress
  79. Set a cron job to delete a specific database table table every midnight
  80. Job and Employee Performance Tracking with Product Safety
  81. SQL database import #1046 error
  82. How to import products in host instead of database on wordpress?
  83. I would like some help wth an SQL query to link posts with categories
  84. Where is the HTML-handler part in the wpdb class?
  85. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  86. Search and Replace in Windows XAMPP site
  87. The function is deprecated; use mysql_real_escape_string() instead
  88. How can i syn wordpress user table with a stand-alone php script?
  89. insert data from a form:: Warning Empty query mysqli::query()
  90. How can I get $wpdb to show MySQL warnings?
  91. How to get specific table by current user login
  92. $wpdb not working
  93. WordPress Database Posts Table query
  94. Hang Up Followed By Can’t select database
  95. How to extract some part of WordPress full source code
  96. Mysql Queries per Visit – Crazy High
  97. using same mysql user with many databases
  98. Why are my WordPress post queries so slow?
  99. Custom wordpress SQL statement for a website
  100. How to find fresh (last modified) and sql backup?