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 the Difference Between VARCHAR and VARCHAR(MAX) Datatypes ...

MS SQL List of Records in All Tables

What are The Different Backup Options With SQL Server ?

Using MS SQL If Else

What is the Difference Between Update Lock and Exclusive Lock in ...