>The question is: how can I tell what the index type is? If I can tell that the index in the table in question has already been changed to a regular index, I obviously will not apply the "fix" a second time. I have not been able to find a command that can tell me that ... anybody know if there is one? If not, any suggestions as to how I can tell the index type so that I don't have to re-index unncessarily?
>
You can use the CANDIDATE() function to check if the index in question is a candidate key (a primary key is just a special instance of a candidate key) or a regular key. You'll need to retrieve the Tag Number for the index in question, sinc the argument passed to the CANDIDATE function is a tag number not a tag name. You can use TAGNO() to retrieve the tag number for a given tag name.