Post reply

adding new column's as Column store index

  • June 20, 2016 at 3:59 am

    #400303

    HI champs,

    I have create columnstore index on table level .

    CREATE CLUSTERED COLUMNSTORE INDEX X_Table_Name ON Table_Name;

    Table was having around 200 columns .

    Now i added another 100 columns for that and i want all them as columnstore index.

    My question is Now these 100 new columns also having that columnstore index by defualt or i need to create it manually ? 😎

    Regards,

    Ravi

  • June 20, 2016 at 11:29 pm

    #1885950

    Hi,

    I guess you need to create another index explicitly.

  • June 21, 2016 at 5:19 am

    #1885985

    SQL 2014, I assume, since you mention clustered columnstore.

    The clustered columnstore is a clustered index, meaning it is the primary storage of the table, hence add columns to the table and they're added to the columnstore. There is no rowstore clustered index or heap here, the table itself is structured as a columnstore index.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply