Sun Java System Directory Server Enterprise Edition 6.0 Reference

System Indexes and Default Indexes

This section addresses the following topics:

System Indexes

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

Table 6–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 6–2 lists the default indexes that are configured in Directory Server.

Table 6–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.