Do fuzzy searches use indexes?

jkj2001 · Post by **jkj2001** » Wed Feb 26, 2003 3:16 pm

Say I have a metamorph index against a field in my database, and I run a fuzzy search against the field. Will the search make use of the index, or will it be linear in nature?

Would I need to pass my "create index" statement some parameters in order to make it fuzzy "friendly"?

Thanks for the advice.

Post by **mark** » Wed Feb 26, 2003 3:20 pm

Please be specific. What sql operator do you mean when you say "fuzzy search"? The "likep" operator uses/requires a metamorph index, or even better, a metamorph inverted index.

See
http://www.thunderstone.com/site/texisman/node51.html
http://www.thunderstone.com/site/texisman/node121.html
http://www.thunderstone.com/site/texisman/node148.html
among others.

jkj2001 · Post by **jkj2001** » Fri Feb 28, 2003 5:47 pm

Sorry-- yes, we're using likep.

Post by **John** » Fri Feb 28, 2003 5:53 pm

Yes, LIKEP will use the index. As Mark said CREATE METAMORPH INVERTED INDEX ... is the most appropriate.