Filtered index does not allow filters on disjunctions - by Ron Talmage

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 341737 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 5/2/2008 5:42:04 PM
Access Restriction Public


Creating a filtered index in SQL Server 2008 does not permit filtering on disjuctions of conjunctions: i.e., ORs of ANDed conditions.

Sign in to post a comment.
Posted by Microsoft on 5/5/2008 at 3:19 PM
Thanks for your feedback regarding the Filtered Indexes feature. In SQL Server 2008, filtered indexes will support a limited set of simple where clauses only. The exact grammar of supported by filter predicates are listed in the BOL (under CREATE INDEX topic). We currently do not support the "OR" clause due to the optimizer matching difficulties for such clauses. We do support the "IN" clause which serves similar purpose in some cases. We will continue to evaluate the supported set of predicates and enhance them in the future releases.

Srini Acharya, SQL Engine