开发者

What should the itemcount property in SQL Server match

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜