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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2004-03-31 : 13:24:00
|
| Hi,When would it become a performance difference between search a varchar field using the LIKE keyword versus FULL-TEXT index on the column/table.I plan to have maybe 100 rows, but i want an idea when it would become a performance difference? |
|
|
LearningSQLDBA
Starting Member
10 Posts |
Posted - 2004-03-31 : 13:35:11
|
| I would be interested in knowing how/why one technique would be chosen over the other.LearningSQLDBA |
 |
|
|
|
|
|
LIKE versus Full-Text