Izvozi (0) Natisni
Razširi vse
EN
Ta vsebina ni na voljo v vašem jeziku, vendar pa je tukaj angleška različica.

sys.dm_db_fts_index_physical_stats (Transact-SQL)

Returns a row for each full-text or semantic index in each table that has an associated full-text or semantic index.

Applies to: SQL Server (SQL Server 2012 through current version).

Column name

Type

Description

object_id

int

Object ID of the table that contains the index.

fulltext_index_page_count

bigint

Logical size of the extraction in number of index pages.

keyphrase_index_page_count

bigint

Logical size of the extraction in number of index pages.

similarity_index_page_count

bigint

Logical size of the extraction in number of index pages.

For information about the status of semantic indexing, query the following dynamic management views:

Permissions

Requires VIEW SERVER STATE permission on the server.

The following example shows how to query for the logical size of each full-text or semantic index in every table that has an associated full-text or semantic index:

SELECT * FROM sys.dm_db_fts_index_physical_stats;
GO

Vsebina skupnosti

Dodaj
Pokaži:
© 2014 Microsoft