What is the Filtered Index in SQL Server ?

Filtered Index is used to index a portion of rows in a table that means it applies a filter on INDEX which improves query performance, reduces index maintenance costs, and reduces index storage costs when compared with full-table indexes. When we see an Index created with a WHERE clause, then that is a FILTERED INDEX



You May Interest

What is Data Collector in SQL Server ?

Disadvantages of Using Stored Procedures in MS SQL

What is NOLOCK Hint in SQL Server ?

Using MS SQL Order By

What is the Difference Between CHAR and VARCHAR Datatypes in SQL ...