ProTop now alerts you to the fact that you have inactive application indexes.
Example alert:
What does it mean?
You may have an application that is unwhittingly running with one or more inactive indexes which may result in poor read performance or ABL failure.
What to do about it?
Scan for inactive app indexes and determine their impact, then respond accordingly.
/*
* This code finds all inactive application indexes and displays
* the name of the table they belong to alongside the index name.
*
* To run: Open Procedure Editor, connect to your database,
* paste this code, and press F2 or Run.
*/
DEFINE FRAME f-inactive
WITH TITLE "Inactive Application Indexes".
FOR EACH _Index NO-LOCK WHERE not _Active,
/* Join to the _File table to get the table name */
EACH _File NO-LOCK WHERE RECID(_File) = _Index._File-recid:
DISPLAY
_File._File-name LABEL "Table Name" FORMAT "x(30)"
_Index._Index-name LABEL "Inactive Index Name" FORMAT "x(30)"
WITH FRAME f-inactive.
END.