Full-text Index Structure Understanding

Full-text Index Structure:

Here we can get a clear idea about the Indexing process:

Let we applying indexing on the following table

ID	Description
1	Student, Pupils, Registration, University and school
2	The Teachers, Lecturer, Professor, University, Registration, 100

Then the FT INDEX look like this>> created by SQL Server: SQL-Server-Installation Path\Microsoft SQL Server\MSSQL.1\FTDATA

Keyword	ColId	DocId	Occ
Student	1	1	1
Pupils	1	1	2
Registration	1	1	3
University	1	1	4
School	1	1	6 (and is a noise word)
Teachers	1	2	2 (the is a noise word)
Lecturer	1	2	3
Professor	1	2	4
University	1	2	5
Registration	1	2	6
100	1	2	7

Columns in the Index table:

Keyword: Contains a single token extracted at indexing time. Word broker determines what makes a single token.

ColId: a value that corresponds to a particular table and Column that are FT indexed.

DocId: a Four-byte integer maps a particular Full-text Key value in a full-text indexed table.
Occ: Represent a particular word offset of the particular keyword within that DocId.