RE: Index only works on 4+ characters?

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

 If I were to change this, to say, 1 or 2 characters, would there be any major negatives, other than increasing the sizes of the indexes?

Thanks, 

Dan


-----Original Message-----
From: Kurt D. Zeilenga [mailto:Kurt@OpenLDAP.org] 
Sent: Monday, April 12, 2004 6:00 PM
To: Armbrust, Daniel C.
Cc: openldap-software@OpenLDAP.org
Subject: Re: Index only works on 4+ characters?

At 02:56 PM 4/12/2004, Armbrust, Daniel C. wrote:
>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