[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: pres indexes: do i need them?

If the attribute is present in all of the entries within
database, then maintaining a presence index for that
attribute is a pointless waste of resources.

At 07:41 AM 2002-10-07, James Shvarts wrote:
>Hi all,
>i was hoping you will help me understand the "pres"ent indexes. i have an entry with the following format:
>dn: uid=jsmith,ou=users,dc=myorg,dc=org
>uid: jsmith
>localUid: 223qadr42
>userPassword: xxxx
>cn: Test User
>mail: jsmith@myorg.org
>objectClass: top
>objectClass: myPerson
>i need to put an index on uid and localUid for faster searches. both attributes will always be present (if not, the application has major problems). the searches will always be based on equality and not on substring or soundex, etc. so my indexing options are:
>index uid,localUid pres,eq
>index uid,localUid eq
>given that both attributes are used as "primary keys" and will always be present for each ldap user entry, do i benefit from adding "pres" index to them?
>thanks a lot!