--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&... 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