Will adding & modifying default WordPress table index break future WordPress update

Adding a BTREE or HASH index shouldn’t break anything, and I imagine that is what you want. At worst you could end up with multiple indexes, or less than optimal ones, which might negatively effect performance. I assume that if you are going to do this you will be evaluating the change to see if it actually does help, rather than hurt.

I guess you could run into trouble with a UNIQUE index, since WordPress does use a couple of those.

Related Posts:

  1. WordPress Unit Testing – Cannot Create Tables
  2. Insert data in database using form
  3. When is it appropriate to create a new table in the WordPress database?
  4. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  5. Prevent changing the length of post_name column on WordPress Update
  6. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  7. Can’t update database after wordpress update from 3.8.1 to 4.4.1
  8. stdObject stored in database. How does one convert it to usable format?
  9. Database with mixed collation (utf8mb4 & utf8_general_ci)
  10. What ALL can cause “Another update is currently in progress.”? [closed]
  11. Trigger Plugin database update after git pull
  12. Moving to another host; which tables to move in a database
  13. WordPress mysql table double prefixes
  14. Are custom tables in the database overwritten when WordPress is updated to new versions?
  15. Change WordPress prefix for only one table?
  16. How to get the SQL of the changes made to the database from an update or upgrade?
  17. input data and output table [closed]
  18. Retrieve data from the database to table such as comments in the admin control panel
  19. Update from 4.5 to 4.6 failing
  20. Migrate database between 2 different wordpress version
  21. Change options table prefix only
  22. Query multiple tables at once?
  23. Is database deleted on clicking “reinstall” button in WordPress updates?
  24. What is the best way to resurrect and update my old WordPress site?
  25. Why does changing Database Table Prefixes result in loss of content?
  26. Can I customised default WP table
  27. Disable Database Update Required ? break my website
  28. Brandoo WordPress Unable to Update to WordPress 4.2.2
  29. Should I use an additional column in the DB?
  30. Updating seperate database when post attachment is changed
  31. What is wrong here? Issue with post_id and meta_value
  32. How to edit custom table data in frontend
  33. How to map data on CSV to web pages?
  34. Adding last value from Database as text in WordPress Page
  35. get_the_terms is not working
  36. Create hundreds of users with just ID in phpMyAdmin
  37. wp-config was suddenly updated
  38. Have WordPress Use a Different Database for users
  39. Difference between partition key, composite key and clustering key in Cassandra?
  40. How SID is different from Service name in Oracle tnsnames.ora
  41. What is a relation in database terminology?
  42. Why WordPress choose data serialization over json_encode?
  43. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  44. Reset Post IDs to less than 64bit integer
  45. how can get database name in wordpress?
  46. Does WordPress use the InnoDB engine for MySQL by default?
  47. $wpdb->prepare() warning in WordPress 3.5
  48. Best way to import users, post and categories from an external database
  49. Performance tips for a large user base [closed]
  50. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  51. wp_options is GB in size
  52. Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
  53. WordPress and automated MySQL backups to a different host
  54. How can I create a Bible search engine via WordPress? [closed]
  55. Error establishing a database connection; After importing DB & Theme
  56. Get all images from this database table
  57. Delete transients in website
  58. wp_get_current_user always returns 0 continued
  59. Bulk-create posts from SQL database
  60. I am switching laptops. I host my WP server through MAMP. I want to transfer [closed]
  61. How can i customize the export personal data file?
  62. Auto login subdomain from main domain on single sites with different DB
  63. Logins from WP users table use on another page
  64. Error establishing a database connection problem in xampp saver
  65. I’m not able to get access to $wpdb [duplicate]
  66. WordPress database connection [closed]
  67. Changing between Local Host DB to Production DB and in reverse
  68. WordPress site to be able to connect with data on local machine of user
  69. Bulk Updating Post Date in 1 day Increments
  70. Query Column of Specific ID from Database Table
  71. Posting variables to WP database using $_POST method
  72. Link image with data from the wpdb
  73. Update multiple rows in one query
  74. Understanding WordPress Search
  75. Error establishing a database connection in wordpress site , website not opening
  76. Counting post and changing roles in mysql database. Query not code
  77. wpdb Insert unknown post data dynamic foreach loop
  78. How do I use a database in a custom theme?
  79. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  80. Migrating meta_key and meta_value from old theme to new one
  81. How do you enable scripts on a WordPress installation in Softaculous?
  82. How to rerieve comments and their replies from DB
  83. Inserting data with Geometry field
  84. Export only a part of the database for migration
  85. Why am I being prompted to reinstall wordpress?
  86. database error WordPress move from one hosting to other
  87. Select data from foreach loop and send it to wordpress database
  88. Error establishing database connection error during first WordPress run
  89. Same DB for live and dev versions
  90. update multiple user meta field based on another meta field
  91. After renaming MySQL database, I can no longer access my Blog page
  92. execute custom function on database connection error
  93. Call to a member function insert()
  94. Create a new table on the database and save parameters from a contact form
  95. not saving post in wp_post wordpress database table
  96. How to add data from wordpress tables to new database tables you have created
  97. How to back-up a database on IIS
  98. Where are database files of a WordPress website?
  99. Cant Connect to Database
  100. WordPress database connection failed, while mysql client is working [closed]