in the incorrect rule set 18 and generates a list of the indexes which match a rule in incorrect rule set it then searches the application data dictionary or program source libraries comparing the application programs 22 with the indexes matching the incorrect rules and generates a list of programs which match a rule in incorrect rule set 18 as noted above inspection system 14 could also be implemented in a real time or online code inspection tool where it can review a program as it is being written compiled interpreted or run in order to prevent programs that access tables incorrectly from being written and added to the application system the list of indexes and programs are merged and reported according to rule in the incorrect rule set 18 in this way administrators can determine the indexes that could be removed and all the programs that depend on each index after the programs have been updated the database administrators can delete the index the rule sets 18 20 can be updated and the process can be re run as additional examples of redundantly stored data items are introduced to the application or found in the application an example of the process is described below with reference to the flow diagram shown in fig2 consider the table data model information for an application shown.