You can use the Control Panel to create, configure, and delete local database indexes and Virtual List View (VLV) indexes. A local database index is used to find entries matching search criteria. A VLV index is used to process searches efficiently with VLV controls. Unindexed searches are denied by default unless the user has the unindexed-search privilege. For more information, see Root Users and the Privilege Subsystem.
This procedure shows how to display a list of all the indexes configured for the directory server.
If your clients search on particular attribute frequently, you can add an index for that attribute to return results more efficiently.
The New Index window appears.
The entry limit is the maximum number of entries allowed in the index before the directory server stops maintaining the index.
approximate-Used to help improve the efficiency of searches using approximate equality search filers.
equality-Used to help improve the efficiency of searches using equality search filters.
ordering-Used to help improve the efficiency of searches using "greater than or equal to" or "less than or equal to" search filters. In the future, this index type might also be used for server-side sorting.
presence-Used to help improve the efficiency of searches using presence search filters.
substring-Used to help improve the efficiency of searches using substring search filters.
The Index Rebuild Required window appears.
Otherwise, to rebuild the index later, click the No button. However, the index does not improve search efficiency until it is built.
If you select the Yes button, the New Index window displays the progress of the rebuild operation.
The New VLV Index window appears.
A unique name to identify the VLV index
The base DN where you want to apply the new VLV index. If you select Other, enter the DN in the empty field to the right.
The search target where you want to apply the index
The LDAP filter used in the query being indexed, which can be any valid LDAP filter
The number of entry IDs to store in a single sorted set before it must be split.
The names of the attributes by which the entries are sorted and their order of precedence, from highest to lowest.
Select the name of each attribute from the list of available attributes, select a sort order for the attribute (either Ascending or Descending) and then click the Add button to add the attribute to the list below. Adjust the position of a selected attribute in the sort order list as needed by clicking the Move Up and Move Down buttons. Remove a selected attribute from the sort order list by clicking the Remove button.
The VLV index is configured, but it is not used for search operations until it has been rebuilt for the first time.
If an index is not used, you can delete it and release the resources that it uses.
The contents of an index can become incorrectly organized. You can verify that any or all indexes are correctly prepared for effective searching. If the verification operation shows that an index is not correctly organized it, rebuild indexes as described in To Rebuild Indexes.
The Verify Indexes window appears, displaying all configured indexes in a list on its left side.
Verify Entry Contents are Properly Indexed
Verify All Index Key ID's are Clean and Refer to Existing Entries
The Verify Indexes window displays the status of the operation
Over time, as new entries are added, an index can become less efficiently organized. You can rebuild any or all indexes to organize them most efficiently.
The Rebuild Indexes window appears, displaying all configured indexes in a list on its left side.
The Confirmation Required window appears, asking you to confirm that you want to rebuild the selected indexes.
The Rebuild Indexes window displays the status of the operation.
While the indexes are being rebuilt, the back end is disabled and none of its suffixes can be accessed.