RE: slow search on indexed attribute

["Armbrust, Daniel C." <Armbrust.Daniel@mayo.edu>]

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.

Kurt  



---

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.

Dan