Re: MDB indices operations (MIT Kerberos with OpenLDAP backend)

[Quanah Gibson-Mount <quanah@symas.com>]

--On Wednesday, September 18, 2019 2:41 PM +0000 Дилян 
Палаузов <dpa-openldap@aegee.org> wrote:

> Hello,
>
> https://www.openldap.org/software/man.cgi?query=slapd-mdb&apropos=0&sekti
> on=0&manpath=OpenLDAP+2.4-Release&format=html (man slapd-mdb) is not
> clear about indices.
>
> Is
> olcDbIndex A eq
> olcDbIndex B eq
> the same as
> olcDbIndex A,B eq
> and is the latter the same as
> oldDbIndex B,A eq
> ?  In the SQL word these are different things and while Postgresql is
> supposed to handle "index A,B" and "index B,A" as equivalent, it does
> not, so a query has to be tuned to make use of existing indices.

LDAP is not SQL.

All of these are equivalent:

index A eq
index B eq

OR

index A,B eq

OR

index B,A eq

OR

index default eq
index A
index B

OR

index default eq
index A,B

OR

index default eq
index B,A

In all of the above cases, "A" will have an equality index created for that 
attribute, and "B" wil have an equality index created for that attribute. 
There are is no concept of "combined" indices for two attributes.

--Quanah

--

Quanah Gibson-Mount
Product Architect
Symas Corporation
Packaged, certified, and supported LDAP solutions powered by OpenLDAP:
<http://www.symas.com>