We are having 22 indexes built on an informix table. This is used in Peoplesoft. We would like to drop a few indexes which are least useful with respect to the performance of Peoplesoft objects.
The approach we have is to identify the sqls that may be using the indexes and run Explain on the query. This needs to be done before and after disabling the index.
We would like to have an alternate approach to identify the least useful tables, which would be less manual and probably use the informix system tables or logs.

Hi,

One question: You run update statistics daily ?
Run update statistics HIGH for header index and MEDIUM for another columns in the index.
After this, check with explain, the indices used and the sql's used.
I think that you must aplication check and re write some SQL's.

Gustavo.