Re: Fulltext Search or Like Search

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:uo8ZEAyBHHA.4892@xxxxxxxxxxxxxxxxxxxxxxx
Full text for English will break words at white space. So bic black pen
would be broken as three words, bic, black and pen. Dispensers would be
broken as dispensers. In a free text search this would match with
dispensers, dispenser, dispenser's, and dispensers.

I would like to do the opposite.
When searching for "pædagog" I also want to return results that contain
"dagplejepædagog" or "pædagogmedhjælper" is ther no other way to accomplish
this than using LIKE '%pædagog%'.
Performance using LIKE is very poor, how do I improve performance?

Kind Regards,
Allan Ebdrup


.