The database fragmentation repair script features a basic layout for easy of use.

This can be installed on your server as a small site, or added to your administrative pages.

The Database Index application consists of: 

• Index Status Page
  The start page for the admin section.  This shows the tables and indexes that are over your desired fragmentation level. You can run the script to fix a index from this page.
  
  
• Table Size
  This section lists all tables in your database with the number of records and the space used.  Allows for trouble shooting and finding large tables that may have unnecessary data.
  
  
• Table list
  Shows all the tables in your data base.  Lists the current indexes on each table. Displays a count of the number of tables with indexes, and without indexes.
  
  
• Logs
  Displays the number of actions taken to repair fragmented indexes. Also shows the tables with the most repairs, giving an idea to where your database is fragmenting the most.

Currently available in .net and Adobe Cold Fusion.

Designed to work with Micro Soft SQL server. MS SQL Server connections with ODBC allow the BIT Index scripts to read all tables and index status in your target database.

Updates for PHP and Ruby on Rails are in progress.

Interested in this working for another scripting language or have other questions?  Contact Us