Tags

,


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.

Advertisements