Building an Ad Hoc Index

From the Ad Hoc Index Browser, the Build Index command from the Ad Hoc Index menu enables you to build an unpopulated ad hoc index definition that is currently selected in the table on the browser.

To build an ad hoc index definition

1. In the Ad Hoc Index Browser, select the unpopulated index definition that you want to build.

2. Select the Build Index command from the Ad Hoc Index menu.

The background color of the Status column changes to yellow while the index in a dynamic dictionary instance is being built (populated), and to green and Populated and available is displayed when the population of the index is complete. A new partition to be used by that instance is created.

The build process drops any existing ad hoc index dictionary and creates a new one. It turns off auditing on the new partition created for the dictionary. It then populates the defined dynamic dictionary. A commit of the transactions is performed every five seconds, by default. When the build completes, auditing is turned back on for the partition. (You can use the Cancel Build Index command to cancel the building of an index.)