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. Editing a WordPress post content from the database does nothing
  40. Set limitations of wp_update_post()?
  41. Database table prefix different between wp-config.php and in database
  42. Count views without get_post_meta
  43. What is this JavaScript “require”?
  44. Example of a strong and weak entity types
  45. MariaDB as a backend database
  46. WordPress database error: [Query was empty] [closed]
  47. Login in WordPress using external database data
  48. What is the fastest way to generate a unique id number when registering a user
  49. How best to inject ads between posts in the loop?
  50. Error establishing a database connection – with Debug Data
  51. Does thumbnail regeneration edit the database?
  52. Using table lock with wp_insert_post?
  53. WordPress doesn’t show all posts in database
  54. Adding new row to wp_post table
  55. Extracting the post_id via the wp_insert_post action (external db query)
  56. What is the proper way to validate and sanitize JSON response from REST API?
  57. How do I get the posts within a certain year/date(with sql query)?
  58. batch UPDATE autoload value in wp_options table
  59. Displaying BLOB PDF File
  60. How to fix the disappearance of the “\” character when updating a post in the database
  61. Data storage for JS app using WP REST API
  62. WP CLI Core install – blank database
  63. Setup 3 Sites To Connect To 1 Database and Share Data
  64. How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
  65. Does auto_load to ‘no’ in wp_options improve performance
  66. How to access custom WordPress database tables
  67. Remove empty rows from the database
  68. Custom WordPress Table wpdb
  69. Check if post id exist in table than only update instead of inserting new row
  70. Detail explanation of wordpress database fields and metatag list [closed]
  71. CreateOrUpdate in WordPress
  72. $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
  73. How to get a list of WordPress default database tables?
  74. Can local WordPress installs share /wp-content/ folder and database?
  75. Stringing together content from different databases
  76. Backing up WordPress database and files
  77. Safely store code(html/js..) into database
  78. Displaying table data on a page
  79. muliple wordpress installs (network) on different databases
  80. White Screen in Home Page
  81. Continuous SQL query errors from outside source
  82. Whats the best practise on how to store json data from a custom settings page?
  83. $wpdb->delete not working for me
  84. Recovery – Restore Database after moving folder location locally
  85. Migrate Users From laravel to wordpress
  86. Job and Employee Performance Tracking with Product Safety
  87. how add more field to wp user and save it to database
  88. How do I cleanup my database with data that is no longer being used?
  89. Malware in old website – how to migrate?
  90. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  91. How to optimize wp_option table?
  92. How to display $wpdb->insert_id; value on redirected page
  93. Should I Use only wpdb Class to Write Custom Queries?
  94. Catchable fatal error in formatting.php
  95. Wrong url for the images while using same database for two WordPress installations
  96. Sending WordPress database information to cross domain the safe way?
  97. Database Name Change
  98. Where To Find bb_profile_data(); In bbPress?
  99. Attach posts based on category and position
  100. Combining two select posts from mysql – to get least viewed posts