DB Index

This module provide the user interface to add or drop the database Table indexes for the Mysql databases. Using this module you can have the information about what all are the Indexes with associated columns and its Tables.

By navigating to the 'ADD NEW INDEX' tab , you will get the option to add new index for the selected tables.

Be very careful about the functionality for dropping the indexes. Make sure that before you trying to do that you have working database backup. Don't try to drop the default indexes, It may cause the feature problems.

REQUIREMENT

• Mysql 5.6 or above version

How does Database indexing help performance:

• https://www.lullabot.com/articles/slow-queries-check-the-cardinality-of-your-mysql-indexes

Usage

• Download and extract to the module folder.
• Navigate to path 'admin/modules' and enable the module
• Click on the 'configure' wheel button or go to the path 'admin/db/index'
• Make sure to 'clear the cache' that ones you added the new index