http://blogs.technet.com/andrew/archive/2008/05/22/sql-server-2008-filtered-indexes-vs-index-views.aspxSQL Server 2008 has a new feature called filtered indexes which are like normal table indexes only they have a simple where clause, meaning that the index will only cover rows specified in the where clause. As I have mentioned before an obvious exampleen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.technet.com/andrew/archive/2008/05/22/sql-server-2008-filtered-indexes-vs-index-views.aspx#3059985Fri, 23 May 2008 18:49:34 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3059985Andrew_Fryer<p>I have had to amend this post as the orignal version had a link to an internal Microsoft site. Thanks to Bob Beachemin (<a rel="nofollow" target="_new" href="http://sqlskills.com/blogs/bobb/">http://sqlskills.com/blogs/bobb/</a>) for pointing this out and Srini Acharya on the relational product team for pointing me in the right direction.</p>