sp_optimize_text_index

Description

Performs optimization on a text index.

Syntax

sp_optimize_text_index index_table_name

Parameters

index_table_name

is the name of the text index you want to optimize. index_table_name has the form [dbname.[owner.]]table, where:

Examples

Example 1

sp_optimize_text_index "i_blurbs"

Optimizes the text index i_blurbs to improve query performance.

Usage

Messages

Permissions

Any user can execute sp_optimize_text_index.

See also

“Updating existing indexes”