Summary

A missing index on the directory_objects table can potentially cause Directory Server 9.2 to have slower than expected performance when retrieving lists of existing users, groups, and devices.

Resolution

Manually run the following SQL statement to create an index on the directory_objects table in the Directory Server licensing database.

create index directory_objects_type_ix on directory_objects (type);