I want to know what is filtered index in SQL server.
Thank you
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jul 16, 2012, 7:54 AM
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 NayakPosted Jul 16, 2012, 6:46 AM
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