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 |
|
.net_tony
Starting Member
2 Posts |
 Posted - 2009-03-12 : 17:03:55
|
| hi all,I use full text index (sql server 2005) to search several million rows on a column of TEXT type. I only search a very small set of keywords. So there is no need to index all the words. Is there anyway to build a custom index only on the few words that I'm actually going to search on? I know that noise words can filter out the words that I'm not interested. But in my case, I kinda need the opposite of the noise words approach because most of the words in the rows will be noise words...If I understand it correctly, IFilter is only for searching different format of the documents. So it won't help in my case...Any suggestions?thanks in advance.Tony. |
|
|
.net_tony
Starting Member
2 Posts |
Posted - 2009-03-13 : 12:52:25
|
| Also can some one tell me how to see the keywords that are used to build the full text index? There should be a system table or view somewhere...thanks in advance.Tony. |
 |
|
|
|
|
|
Full text index question: Is it possible to build