When you have defined the membership and keys of your ad hoc index and clicked the Next button, the Text sheet of the Define Ad Hoc Index dialog is displayed, to enable you to specify a textual description of the ad hoc index, if required.
An example of the Text sheet is shown in the following image.
To specify descriptive text for your ad hoc index
In the editor pane, enter the required descriptive text. (For details about specifying text, see "Specifying Text for a Schema Element", in Chapter 3.)
The editor determines the behavior of the text editor window. Text is not automatically wrapped to fit the current window size. When you want text to start in the next line, press Ctrl+Enter. (If you want text to wrap in text windows, see "Maintaining Editor Options", in Chapter 2.)
Click the OK button. Alternatively, click the Cancel button to abandon your ad hoc index selections.
The ad hoc index definition is then validated and created, with the status of Unpopulated. The definition is rejected if it matches an existing ad hoc index definition.
A warning is displayed if the descending attribute varies between keys (as it may impact on the ability for the index definition to be optimized) or if another ad hoc index or an existing MemberKeyDictionary with the same membership and keys exists (even if they have more keys).
Key paths are not supported, as they cannot be directly referenced by ODBC select statements.
