Filtered Index in SQL Server

Question

I want to know what is filtered index in SQL server. Thank you

Jignesh Trivedi · Answer

hi A Filtered Index which is an optimized non-clustered index allows us to define a filter predicate a WHERE clause while creating the index.it is new in SQL server 2008. it is normal table indexes only they have a simple where clause. Please refer http://sqlinthewild.co.za/index.php/2011/11/09/sql-university-advanced-indexing-filtered-indexes-2/ http://msdn.microsoft.com/en-us/library/ms188783.aspx hope this will help you.

Satyapriya Nayak · Answer

Hi Vipendra Please refer the below links http://blog.sqlauthority.com/2008/09/01/sql-server-2008-introduction-to-filtered-index-improve-performance-with-filtered-index/ http://www.mssqltips.com/sqlservertip/1785/sql-server-filtered-indexes-what-they-are-how-to-use-and-performance-advantages/ Thanks