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

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.