How to find unused indexes

Carmen_S

We have a 3.10 native database running on a 3.7 executable. I would like to know if there is any easy way to determine if there are unused indexes.

kapamarou

Developer's toolkit is a good start... It will show you all references to the indexes (Where used) plus flowfields that might (or might not) use them. You also need to investigate your code manually. It's a dirty job... but the results are worth it...

Tarek_Demiati

You may also want to check out the Unused Key tool, available here :

http://www.mibuso.com/dlinfo.asp?FileID=755

Carmen_S

Thank you both Kapamarou and Tarek for your suggestions. I will try them and post the result.

Regards,
Carmen