locked
IS Filtered index feature available in sql server 2008 R2 standard edition? RRS feed

  • Question

  • Is Filtered Index feature available on sql server 2008 R2 standard edition, or is it specific to enterprise edition only?

    This isnt available on the feature comparision list of different editions of SS 2008 R2.

    Thanks.


    Tuesday, April 19, 2011 3:50 PM

Answers

  • Hi bal00n,

    The feature of Filtered index is not listed on the comparison of SQL Server 2008 R2 editions. By default, it is available for all editions.  You can try to create an index filtered on SQL Server 2008 R2 Standard edition.

    Best Regards,
    Stephanie Lv

    • Marked as answer by WeiLin Qiao Thursday, April 28, 2011 11:25 AM
    Thursday, April 21, 2011 8:17 AM

All replies