locked
SQL Server Editions for Columnstore Indexes RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I am trying to find out what editions of SQL Server 2012 will allow the use of columnstore indexes.  Can I create and use columnstore indexes on the standard edition or do I have to have the BI or Enterprise editions?

    Lee Markum


    • Edited by Lee Markum Thursday, March 20, 2014 2:26 PM
    Thursday, March 20, 2014 2:25 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Column store index is supported only in SQL Server Enterprise edition.

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

    http://technet.microsoft.com/en-us/library/gg492153.aspx

    -Prashanth

    • Edited by Prashanth Jayaram Thursday, March 20, 2014 2:40 PM added links
    • Proposed as answer by Olaf HelperMVP Thursday, March 20, 2014 2:40 PM
    • Marked as answer by Lee Markum Thursday, March 20, 2014 4:09 PM
    Thursday, March 20, 2014 2:32 PM