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:
- WordPress Unit Testing – Cannot Create Tables
- Insert data in database using form
- When is it appropriate to create a new table in the WordPress database?
- Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
- Prevent changing the length of post_name column on WordPress Update
- BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
- Can’t update database after wordpress update from 3.8.1 to 4.4.1
- stdObject stored in database. How does one convert it to usable format?
- Database with mixed collation (utf8mb4 & utf8_general_ci)
- What ALL can cause “Another update is currently in progress.”? [closed]
- Trigger Plugin database update after git pull
- Moving to another host; which tables to move in a database
- WordPress mysql table double prefixes
- Are custom tables in the database overwritten when WordPress is updated to new versions?
- Change WordPress prefix for only one table?
- How to get the SQL of the changes made to the database from an update or upgrade?
- input data and output table [closed]
- Retrieve data from the database to table such as comments in the admin control panel
- Update from 4.5 to 4.6 failing
- Migrate database between 2 different wordpress version
- Change options table prefix only
- Query multiple tables at once?
- Is database deleted on clicking “reinstall” button in WordPress updates?
- What is the best way to resurrect and update my old WordPress site?
- Why does changing Database Table Prefixes result in loss of content?
- Can I customised default WP table
- Disable Database Update Required ? break my website
- Brandoo WordPress Unable to Update to WordPress 4.2.2
- Should I use an additional column in the DB?
- Updating seperate database when post attachment is changed
- What is wrong here? Issue with post_id and meta_value
- How to edit custom table data in frontend
- How to map data on CSV to web pages?
- Adding last value from Database as text in WordPress Page
- get_the_terms is not working
- Create hundreds of users with just ID in phpMyAdmin
- wp-config was suddenly updated
- Have WordPress Use a Different Database for users
- Editing a WordPress post content from the database does nothing
- Set limitations of wp_update_post()?
- #1067 – Invalid default value for ‘post_date’ when trying to create a new column
- wp_update_post function exclude specific field
- Database table prefix different between wp-config.php and in database
- Count views without get_post_meta
- What is an ORM, how does it work, and how should I use one? [closed]
- What is the difference between an ORM and an ODM?
- What is this JavaScript “require”?
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- What is this JavaScript “require”?
- What is “Advanced” SQL?
- What’s the difference between identifying and non-identifying relationships?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- What are the differences between B trees and B+ trees?
- MySQL SELECT increment counter
- How to resolve ORA-011033: ORACLE initialization or shutdown in progress
- Example of a strong and weak entity types
- Oracle SQL query for Date format
- phpMyAdmin – Error > Incorrect format parameter?
- Strange Characters in database text: Ã, Ã, ¢, â‚ €,
- Difference between partition key, composite key and clustering key in Cassandra?
- How SID is different from Service name in Oracle tnsnames.ora
- What is a relation in database terminology?
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Database vs File system storage
- Can I have multiple primary keys in a single table?
- Exclude Statement in SQL
- How do you query for “is not null” in Mongo?
- What is a file based database?
- Is it fine to have foreign key as primary key?
- Storing Images in DB – Yea or Nay?
- Using wpdb to connect to a separate database
- how to Optimize WordPress database for 10 million post? [duplicate]
- MySQL Database User: Which Privileges are needed?
- Why is my database import losing text widget data?
- Database synchronization between dev/staging and production
- Keeping WP database synced across multiple developers using git
- WPDB Insert or if exists Update
- Multiple developers / editors working on a site in progress
- Where are wordpress custom types stored?
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- Is it mandatory to use $wpdb->prefix in custom tables
- get_results using wpdb
- Will it break my site if I delete all transient records in wp_options table?
- Checking if Database Table exists
- Why WordPress choose data serialization over json_encode?
- What’s the simplest way to backup my WordPress database?
- WordPress (MyISAM) database is slow, should I switch to InnoDB?
- $wpdb won’t insert NULL into table column
- Relaunch 4.2 utf8mb4 database upgrade
- Fastest way (least amount of steps) to locally import a remote database using WP-CLI
- Safest way to bulk delete post revisions
- Please explain how WordPress works with MySQL character set and collation at a low level
- Solution for database version control and deployment?
- The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
- How many users can WordPress handle?
- Get error messages when $wpdb->insert() returns false?
- Detecting errors generated by $wpdb->get_results()