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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-23 : 08:07:44
|
| Leroy Bird writes "Why are full-text qureies so important for Internet applications and web sites?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-23 : 20:03:30
|
| You can definitely get by without full-text capabilities, but it allows for you to index words and phrases and to match word forms, not just the exact words. So searching for "foot" or "feet" using full-text algorithms should get you nearly the same results, whereas an exact word match using LIKE or CHARINDEX probably wouldn't. Searching for words is much faster too since each word in a sentence or paragraph are indexed, unlike regular relational data, and you can rank or weight the results based on how many times the word occurs in the text.Books Online explains full-text indexing and searching in more detail. |
 |
|
|
|
|
|
SQL server full- text query