Remove Duplicate Table Indexes: Install New Updates
Link: https://support.brilliantdirectories.com/support/solutions/articles/12000109016
The Install New Updates module on the admin dashboard lists one-time platform installers that have pending steps for your specific website. Click the green Check For Updates button to refresh the list — an installer only appears when your site actually has something left to install, and it disappears from the list once its steps are complete.
What Remove Duplicate Table Indexes Does
A database index is like the index at the back of a book: it lets the database jump straight to the rows it needs instead of reading every row in a table. Over years of platform updates, a table can occasionally end up with two indexes that cover exactly the same columns. The extra copy adds no speed benefit, but the database still has to maintain it every time a row is added or changed, and it takes up disk space.
This installer scans every table in your website's main database and, wherever it finds two or more indexes covering the identical set of columns, keeps one and removes the redundant copies. Specifically, it lists the indexes on each table, compares their column lists, treats indexes with the exact same columns in the same order as duplicates, and drops the extra ones with a standard database command (ALTER TABLE ... DROP INDEX).
Removing an index does not change the data stored in your tables. Your members, posts, settings, and all other content are untouched, and because an identical index remains in place for every one that is removed, lookups stay just as fast.
Why It Appears
This installer only appears when the scan actually finds at least one duplicate index in your database. That situation is most common on older websites, where different platform updates over the years may have added an index that already existed under another name. If your database has no duplicates, the installer stays hidden.
Why It Matters
This is housekeeping rather than a dramatic change. Each duplicate index takes up some disk space and adds a small amount of extra work on every insert or update, because the database maintains every index on a table. Removing the duplicates trims that overhead and slightly reduces database size. It will not make your pages noticeably faster on its own, and it removes nothing your site actually uses.
How to Run It
- From the admin dashboard, find the Install New Updates module and click Check For Updates.
- If your site has pending steps, Remove Duplicate Table Indexes appears in the list. Click Install.
- After it completes, click Check For Updates again — the entry disappears once all steps are done.
If Remove Duplicate Table Indexes does not appear in the list, your website is already up to date — the module only shows installers with pending steps, so there is nothing to do.
After Running
Nothing on your website looks or behaves differently afterward. Searches and page loads continue to work exactly as before, because one copy of every index is kept, and no content or settings are affected. You should see a confirmation that the duplicate indexes were removed. Click Check For Updates again and the entry disappears once the scan finds no remaining duplicates. There is nothing to verify or configure afterward, and the installer is safe to run whenever it appears.
