SQL Server 2008重新填充索引“更新”选项
我创建了一个名为 EntryCatalog 的目录。我将一个名为 Entry 的表分配给目录，并选择“注释”和“标题”列（均为 nvarchar max），并将“跟踪更改”设置为“自动”。
我没有在填充计划选项中添加任何内容，认为必须有某种方法让它自动填充并进行“自我管理”。因此，在条目表的 FTI 属性中，有一个“操作”复选框。我检查了这一点并选择了“更新”单选按钮（而不是“增量”或“完整”），因为文档说“只要修改基表中的数据，就会更新全文索引”。我认为这就是我想要的...这是否适用于向条目表进行插入时？
也许我从根本上误解了 FTI 的工作原理。我希望我可以设置一个目录来索引该表中的两列，并且当插入新记录时，它们也会自动索引。这可以完成吗？或者您是否必须设置某种调度选项？这真的是重新人口增长吗？
谢谢。
I have created a single catalog named EntryCatalog. I assigned a table named Entry to the catalog and selected Notes and Title columns (both nvarchar max) with Track Changes set to Automatic.
I did not put anything in the Population Schedule options thinking there has to be some way to have it populate automatically and kind of "manage itself." So in the FTI properties for the Entry table there is an Actions checkbox. I checked that and selected the UPDATE radio button (rather than Incremental or Full) because the docs say "The full-text index is updated whenever the data in the base table is modified." I think that's what I want...does this apply to when inserts are made to the Entry table?
Maybe I'm fundamentally misunderstanding how FTI works. I'm hoping I can just set up a catalog to index the 2 columns in this table and when new records are inserted they are indexed as well automatically. Can this be done, or do you HAVE TO have some kind of scheduling option set up? Is that what repopulating really is?
Thank you.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
那么，要在 SQL Server 中实现全文索引，您应该执行以下步骤：
答案：是的
如果我没记错的话，你就不必做这样的事情。事物将由 SQL Server 2008 自动管理。首先，您需要创建全文目录，创建全文目录后，您就可以创建全文索引了。然后，您可以将索引与新目录相关联。然后修改停用词。你完成了。
以下链接将帮助您了解“SQL Server 中的全文索引”的基础知识。
http:// www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/
希望这有帮助！
Well, To implement full-text indexing in SQL Server, you should take the following steps:
Answer: YES
If I'm not wrong you don't have to any such thing. Things will be managed by SQL Server 2008 automatically. First you need to create Full-Text Catalog and after you create your full-text catalog, you’re ready to create your full-text index. You can then associate the index with the new catalog. Then modify stop words. You are done.
The following link will help you to understand the basic of "Full-Text Indexing in SQL Server".
http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server/
Hope this helps!