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 - 2001-02-07 : 17:59:43
|
| Jarek writes "Thanks in advance for any time spend on my question. I wonder if you guys have any tips on how to improve search performance on full-text indexed varchar(128) column. I have around 3 million records. Using sproc and search "contains (phrase,'mySearch')", it takes around 20 second. Platform SQL 2000, Pentium 555, 256 RAM . Thank you Jarek." |
|
|
|
|
|
how to optimize search on 3 millions varchar records