Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Oliver wang
Yak Posting Veteran
50 Posts |
 Posted - 2011-06-29 : 02:26:53
|
| Hi Everyone,Recently I'm researching on how to use full text search. It seems this function can provide us a way to do some "fuzzy search". But I think the T-SQL "like" can also do the same. Can anybody shed light on the competitive edge of using full text search? Thanks in advance.Regards,Oliver |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-06-29 : 02:48:44
|
Found this:http://stackoverflow.com/questions/478472/sql-full-text-search-vs-likeFull-text indexes (which are indexes) are much faster than using LIKE (which essentially examines each row every time). However, if you know the database will be small, there may not be a performance need to use full-text indexes. The only way to determine this is with some intelligent averaging and some testing based on that information.Accuracy is a different question. Full-text indexing allows you to do several things (weighting, automatically matching eat/eats/eating, etc.) you couldn't possibly implement that in any sort of reasonable time-frame using LIKE. The real question is whether you need those features.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Oliver wang
Yak Posting Veteran
50 Posts |
Posted - 2011-07-01 : 04:06:24
|
| Hi webfred, Thanks a million for your sharing which is really helpful.regards,Oliver |
|
|
|
|
|
|
Full text search