Thunderstone Support Forums

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.

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.

Sorry-- yes, we're using likep.