How Does Sql Server Full-text Index Actually Index The Words In A Catalog?
I have been searching long and hard for an answer regarding the processes full-text index uses to index the full text catalogs assigned to a document, where the document primary ke
Solution 1:
After a lot of testing, (and turning off the StopList, which prevented indexing the integer-only strings --which the author of the article linked DID do) it looks like it indexes every string delimited by a space, including the integers. I believe the words that are actually indexed go in the catalog using information about the row, column, and sort of cell within that column, or position, rather.
Everything in that entire table gets a relational index, as long as it is space-delimited.
Post a Comment for "How Does Sql Server Full-text Index Actually Index The Words In A Catalog?"