>I have used the Rapid Application Technique of creating and index for every field in my entire database. Now that the application has been created and is being used I need to optimize for performance starting with eliminating unused indexes. Is there an easy way to figure out what indexes in my application are being used? I have everything in a project.
You would have to parse your project for ORDER (SET ORDER TO IndexKey, USE MyTable ORDER IndexKey).
You may want to retain some indices for optimization - but by no means all (see FAQ#8109).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
