Performs optimization on a text index.
sp_optimize_text_index index_table_name
is the name of the text index you want to optimize. index_table_name has the form [dbname.[owner.]]table, where:
dbname is the name of the database containing the index table. If present, the owner or a placeholder is required.
owner is the name of the owner of the index table.
table is the name of the index table.
sp_optimize_text_index "i_blurbs"
Optimizes the text index i_blurbs to improve query performance.
sp_optimize_text_index is available only with Enhanced Full-Text Search Specialty Data Store.
This system procedure causes the Enhanced Full-Text Search engine to run the specified text index through the Verity optimization routines.
sp_optimize_text_index is useful for optimizing a text index that has been updated with Verity optimization disabled (trace flag 11 turned on).
To enable MaxClean optimization, turn on trace flag 30. This trace flag should only be used during maintenance since it could take extra time and interfere with normal usage. MaxClean is a Verity optimization feature that removes out-of-date collection files.
‘index_table_name’ is not in the current database.
‘index_table_name’ does not exist.
Index ‘index_table_name’ is not a text index.
This procedure is not supported against remote server ‘server_name.’
Any user can execute sp_optimize_text_index.
