Online Documentation for SQL Administrator for SQL Server

Filter


Use the Filter tab to set the filter predicate for the index.

 

Index Editor - Filter

 

 

Filter

Use this text field to specify which rows to include in the index to create a filtered index. The filtered index must be a nonclustered index on a table. Creates filtered statistics for the data rows in the filtered index.

 

The filter predicate uses simple comparison logic and cannot reference a computed column, a UDT column, a spatial data type column, or a hierarchyID data type column. Comparisons using NULL literals are not allowed with the comparison operators. Use the IS NULL and IS NOT NULL operators instead.