开发者

What should the itemcount property in SQL Server match

开发者 https://www.devze.com 2022-12-22 05:51 出处:网络
If the itemcount property does not exactly match the number of indexed rows is that a problem? Is there a numerical way I can ensure that I have a complete full-text-index?

If the itemcount property does not exactly match the number of indexed rows is that a problem? Is there a numerical way I can ensure that I have a complete full-text-index?

update: the property fulltextcatalogproperty('database','itemc开发者_开发技巧ount') does not equal the rowcount for the indexed tables. It is off by a few thousand. Does that indicate the index is missing information, or would you expect that itemcount to not exactly match?


In SQL Server 2008, ItemCount won't count records that the FULLTEXT index does not index (NULL, empty, or those containing only the word separators)

Also, when your table is changed heavily, ItemCount can lag and not reflect the changes to the table immediately.

This is a statistical property which only serves as a hint, not as exact value.

0

精彩评论

暂无评论...
验证码 换一张
取 消