Filtered Indexes in SQL

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