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.
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. |
General Remarks
For more information, see Manage and Monitor Semantic Search.
Metadata
For information about the status of semantic indexing, query the following dynamic management views:
Security
Permissions
Requires VIEW SERVER STATE permission on the server.
Examples
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