Filtered Indexes in SQL

Filtered Indexes in SQL Server 6

SQL Filtered Index is a new feature introduced in SQL Server 2008. A Filtered Index in SQL Server is nothing but a non clustered Indexes along with Where Clause. Because of the where clause, indexing will perform on a portion of records (records match where condition). Before we go into examples of creating and deleting Filtered Indexes in … Read more