Home / server / Questions / 245701
Accepted
Ian Ringrose
Asked: 2011-03-11 06:03:10 +0800 CST

Are filtered indexes in all editions of SQL Server 2008?

  • 772

I cannot find anywhere conformation that filtered indexes are in editions of SQL Server 2008 other then developer and enterprise.

(Is the answer the same for SQL Server 2008 r2)

sql-server-2008

3 Answers

  1. Best Answer

    I'm inclined to believe they're supported in all editions. The Books Online article for CREATE INDEX specifically mentions that online and parallel indexing operations are supported only in Enterprise and Developer, but makes no mention of edition restrictions for filtered indexes.

    http://msdn.microsoft.com/en-us/library/ms188783.aspx

    • 1

  2. Filtered indexes are supported in SQL 2008 R2 Std. I just created one. I don't have a plain SQL 2008 instance handy, but they were introduced in 2008 so I'm inclined to think that they are there as well.

    • 1

  3. Features differ between editions, not the actual SQL.

    So CREATE INDEX ... WHERE... must be supported on all editions.

    Indexed views are supported in all versions (CREATE VIEW and CREATE INDEX ... ON MyView..). Its only how the optimiser uses them that differs which is unrelated to the DDL.

    There is a heck of difference in the engine ignoring an indexed viw and ignoring a WHERE clause in an index: that's one hell of a breaking difference.

    • 1