sql server - Full-Text Item Count 1 on Table with 8986 records -
using query
select fulltextcatalogproperty(cat.name,'itemcount') [itemcount], fulltextcatalogproperty(cat.name,'mergestatus') [mergestatus], fulltextcatalogproperty(cat.name,'populatecompletionage') [populatecompletionage], fulltextcatalogproperty(cat.name,'populatestatus') [populatestatus], fulltextcatalogproperty(cat.name,'importstatus') [importstatus] sys.fulltext_catalogs cat
i see
itemcount | mergestatus | populatecompletionage | populatestatus | importstatus ------------------------------------------------------------------------------- 1 | 0 | 872792723 | 0 | null
itemcount 1 on table 8986 records!
if perform simple freetext
query:
select * freetexttable(table, column, 'word')
it return 1 record.
but if perform classik like
query
select * table column '%word%'
it return 332 records.
i have added first time full-text index on existing table auto detect modify , 'italian' word breaker.
why full text index seem have 1 record?
wiki
Comments
Post a Comment