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 |
|
NickRice
Starting Member
13 Posts |
 Posted - 2003-08-27 : 11:30:50
|
| Hi,I have a database table (in SQL Server 2000) with a text field and I need to perform frequent searches on it. The table will have some10,000 records at any given time and the searchable text data in thistable will be updated frequently as well (say 6-10 times a day). Cansomeone please suggest if I should use full-text (index catalog) or aWHERE..LIKE query for my search requirement? Which of the two will befaster, efficient and easy to maintain in the current context? Or isthere any other technique for text data search in SQL Server 2000?Your feedback will be of great help. Thank you :) |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-27 : 11:40:48
|
| Full text query works on words so if you want to search for words then this is not easy in a like statement - catering for all the word terminators. If you don't mind whether you search for words or strings then you have not many records and updated frequently so I would use a like rather than full text query. It would save having to run an incremental full text index update every time you changed any data.This depends a bit on how wide the rows are and how much memory you have.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Full-text or WHERE..LIKE query?