System Indexes and Default Indexes

This section addresses the following topics:

System Indexes
Default Indexes

System Indexes

System indexes are required for Directory Server to function properly and efficiently. System indexes cannot be deleted or modified. Table 9-1 lists the system indexes created automatically in every suffix.

Table 9-1 System Indexes in Every Suffix

Attribute	Equality Index	Presence Index	Description
`aci`		X	Allows the directory server to quickly obtain the access control information maintained in the directory
`ancestorid`	X		Enhances directory performance during subtree searches
`entrydn`	X		Speeds up entry retrieval based on DN searches
`id2entry`	X		Contains the actual database of directory entries. All other database files can be recreated from this one
`nsUniqueId`	X		Used to search for specific entries
`nscpEntryDN`	X		Used internally in Directory Server for replication
`nsds5ReplConflict`	X	X	Helps to find replication conflicts
`numsubordinates`		X	Used by Directory Service Control Center to enhance display performance on the Directory tab
`objectClass`	X		Accelerate subtree searches
`parentID`	X		Enhances directory performance during one-level searches

Default Indexes

When you create a new suffix in your directory, the server configures a set of default indexes in the corresponding database directory. The default indexes can be modified depending on your indexing needs, although you should ensure that no server plug-ins or other servers in your enterprise depend on an indexed attribute before you eliminate index.

Table 9-2 lists the default indexes that are configured in Directory Server.

Table 9-2 Default Indexes in Every New Suffix

Attribute	Equality Index	Presence Index	Substring Index	Description
`cn`	X	X	X	Improves the performance of the most common types of directory searches.
`givenName`	X	X	X	Improves the performance of the most common types of directory searches.
`mail`	X	X	X	Improves the performance of the most common types of directory searches.
`mailAlternateAddress`	X			Used by Messaging Server.
`mailHost`	X			Used by Messaging Server.
`member`	X			Improves server performance. This index is also used by the referential integrity plug-in.
`nsCalXItemId`	X	X	X	Used by Calendar Server.
`nsLIProfileName`	X			Used by roaming feature of Messaging Server.
`nsRoleDN`	X			Improves the performance of role-based operations.
`nswcalCALID`	X			Used by Calendar Server.
`owner`	X			Improves server performance. This index is also used by the referential integrity plug-in.
`pipstatus`	X			Used by other servers.
`pipuid`		X		Used by other servers.
`seeAlso`	X			Improves server performance. This index is used by the referential integrity plug-in.
`sn`	X	X	X	Improves the performance of the most common types of user directory searches.
`telephoneNumber`	X	X	X	Improves the performance of the most common types of user directory searches.
`uid`	X			Improves server performance.
`uniquemember`	X			Improves server performance. This index is also used by the referential integrity plug-in.

Skip Navigation Links
Exit Print View
	Oracle Directory Server Enterprise Edition Reference 11 g Release 1 (11.1.1.5.0)