MS SQL Server 2008 Interview Question:

Explain filtered indexes?

Submitted by: Administrator

Filtered index in SQL Server 2008 is an index WHERE clause. A filtered index is an optimized non-clustered index. It allows for defining the filter predicate with WHERE clause at the time of creating index. The rows from the filtered index are available in B-Tree will contain the rows which only satisfy the criteria of the filter while creating the index.
Submitted by: Administrator