Add an ad hoc index definition to the current schema from the Ad Hoc Index menu in the Ad Hoc Index Browser.
You cannot add an ad hoc index with the same name as an RPS mapping to a schema.
As you cannot manipulate ad hoc indexes on a secondary (including index creation, update, build, or drop actions), all of the Ad Hoc Index Browser menu items are disabled. These actions must be performed on the primary.
To add an ad hoc index
Select the Add command from the Ad Hoc Index menu.
The Define Ad Hoc Index dialog is then displayed. For details, see: