http://blogs.msdn.com/manisblog/archive/2009/07/04/performance-boost-for-sql-queries-filtered-index-in-sql-server-2008.aspxSQL Server 2008 introduces an enhancement to the way the indexes are created which helps to get better performance from the same queries. This new little guy is known as ‘Filtered Index’. This is actually an Optimized Non-Clustered index which is wellen-USCommunityServer 2.1 SP1 (Build: 61025.2)