Indexes and Rulebases

To determine which indexes are required, do a test run and extract the query from the debug log. Then run the results through the database tools.

You need to create only the required indexes because too many indexes slow down Data Manipulation Language (DML) operations.