ProTop can now send an alert when it detects inactive application indexes. And report all inactive indexes in a standalone report. This can help identify inactive indexes where you don't expect them.
This alert definition exists in the ProTop 328+ alert.cfg:
inctveAppIdx num > 0 "" "daily" "There are inactive app indexes &1 &2 &3" alert
It is enabled by default. Copy this line from the latest etc/alert.cfg into your existing alert.*.cfg files if you want to have this alert active for your database.
If you leave this alert uncommented and have inactive indexes, you will receive an alert that looks like this:
When you do, you can generate a report of all the inactive indexes in that database by running this command from $PROTOP, using the sports database as an example:
mpro /data/128/db/noai/sports -b -p util/inactiveappidxrpt.p
This will place a report named sports.inactiveappidx.rpt in your $PROTOP/rpt directory.
The report will look like this:
This will give you the necessary details to figure out whether the reported indexes should be activated.