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 |
|
charuvasudev
Starting Member
1 Post |
 Posted - 2011-07-23 : 08:42:02
|
| Hi,I am working on a project where files are stored in SQL Server2008 in filestream. The table has fields for Filename, File Description, UserNotes, Filestream_data, FileExtn and some other fields like ID etc. I am using FullText Indexing to search contents of the files. I have created a full text index on Filestream_data field. This... works fine. My question is- should I add FileName, FileDescription, UserNotes also to the same full text index, in the same catalog. Since my data can increase many fold, will this spoil the performance of search on Filename,Description and Notes. Would it be much better if I create an index on other fields? I understand that way I would loose out on the linguistic capabilities of FTS on other fields. Pls advise..Thank youCharu Vasudev |
|
|
|
|
|
Full Text Indexing Vs regular index