Table of Contents

Class FullTextSearchSchema.IndexFragment

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.fulltext_index_fragments (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database

A fulltext index uses internal tables called *full-text index fragments* to store the inverted index data. This view can be used to query the metadata about these fragments. This view contains a row for each full-text index fragment in every table that contains a full-text index.


See sys.fulltext_index_fragments.

[Table(Schema = "sys", Name = "fulltext_index_fragments", IsView = true)]
public class FullTextSearchSchema.IndexFragment
Inheritance
FullTextSearchSchema.IndexFragment
Extension Methods

Properties

DataSize

Logical size of the fragment in bytes.

[Column("data_size")]
[NotNull]
public int DataSize { get; set; }

Property Value

int

FragmentID

Logical ID of the full-text index fragment. This is unique across all fragments for this table.

[Column("fragment_id")]
[NotNull]
public int FragmentID { get; set; }

Property Value

int

FragmentObjectID

Object ID of the internal table associated with the fragment.

[Column("fragment_object_id")]
[NotNull]
public int FragmentObjectID { get; set; }

Property Value

int

RowCount

Number of individual rows in the fragment.

[Column("row_count")]
[NotNull]
public int RowCount { get; set; }

Property Value

int

Status

Status of the fragment, one of:

0 = Newly created and not yet used

1 = Being used for insert during fulltext index population or merge

4 = Closed. Ready for query

6 = Being used for merge input and ready for query

8 = Marked for deletion. Will not be used for query and merge source.

A status of 4 or 6 means that the fragment is part of the logical full-text index and can be queried; that is, it is a queryable fragment.

[Column("status")]
[NotNull]
public int Status { get; set; }

Property Value

int

TableID

Object ID of the table that contains the full-text index fragment.

[Column("table_id")]
[NotNull]
public int TableID { get; set; }

Property Value

int

Timestamp

Timestamp associated with the fragment creation. The timestamps of more recent fragments are larger than the timestamps of older fragments.

[Column("timestamp")]
[NotNull]
public object Timestamp { get; set; }

Property Value

object