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