SQL Server全文索引自动填充? [英] SQL Server fulltext index auto population?

问题描述

我有一个带有全文索引的表，该表本质上是几个表的非规范化视图，当通过触发器更新任何基表时，该表会自动更新.该表主要用于夜间操作，但是如果我只能弄清楚人口的话，我想将它用于更实时的事情.

设置全文索引时，我将航迹更改"设置为自动"，因为我不想每晚都必须完全填充索引.但是，一段时间内似乎根本没有合并新添加的记录.我只能通过重建索引来获得要在FREETEXTTABLE查询中返回的新记录.

我尝试每天两次制定人口计划，但这似乎无济于事.我通过查看基表中新插入的记录并在FREETEXTTABLE查询中搜索它们来测试它，期望在搜索结果中显示正确的ID.

在进行在线研究时，我一直认为在后台填充"是一种潜在的解决方案，但我从未见过有关如何真正启用此功能的任何信息.

有任何想法吗?

I have a table with a full-text index that is essentially a denormalized view of several tables that is automatically updated when any of the base tables are updated via triggers. This table is primarily used for a nightly operation, but I would like to use it for more real-time things if I could only get the population figured out.

When setting up the full-text index, I set ''track changes'' to ''Automatic'' as I didn''t want have to fully populate the index every night. However, it doesn''t seem to incorporate newly added records for some time, if at all. I can only get new records to return in FREETEXTTABLE query by re-building the index.

I tried setting up a population schedule twice a day, but that doesn''t seem to do anything. I am testing it by looking at newly inserted records in the base tables and searching for them in a FREETEXTTABLE query, expecting the correct ID to show up in the search results.

When researching online, I kept seeing ''populate in background'' as a potential solution, but I never saw anything about how to actually enable this.

Any ideas?

推荐答案

您看到的背景人口很可能是跟踪变化的另一个术语.

如果您在每晚操作中添加大量数据，建议您在每晚操作之前删除索引，进行操作，然后再次创建索引(以免使用重建).再次创建索引时，将更改跟踪设置为自动，以便索引应跟踪白天的操作.

Most likely the background population you saw is another term for tracking changes.

If you add large amount of data in your nightly operations, I would suggest that you drop the index before nightly operations, do the operations and then create the index again (so not using rebuild). When creating the index again, put the change tracking to auto so the index should keep track on the day time operations.

这篇关于SQL Server全文索引自动填充?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！