[Date Prev][Date Next]
RE: slow search on indexed attribute
Copied from an older e-mail on this list:
>I just ran into an odd occurrence - is there any reason that a search for (attributeName=*abc*) should fail to use an index, while (attributeName=*abcd*) will use the index?
>It looks like if I do a search for 3 or less characters, it fails to use the index.
Because the index key length is defined (in slap.h) to be 4 characters.
I don't know what negative impacts it would have on your database to change this key length, I suspect it would result in much larger (and slower) indexes.