While I cannot speak to the design choices made here, I can say that, in general, you are better off having a single table on which to perform a full text search as opposed to a larger group of tables in most situations. I would assume in this situation that the overhead of 110 queries would cause poorer performance than a single table search. The full text works better when it can eliminate duplicate words by having a larger data set.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
As for the Soundex function, such a performance is intended for finding words by sound when the spelling of a word cannot be relied upon. This make it useful for things such as name searching where the user may not spell the name correctly. It may be of limited use depending on context.
Dig Deeper on Open source databases
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.