SQL Server COLUMNSTORE table RRS feed

  • Question

  • Someone on our development team is saying that they've created a columnstore TABLE with mssql 2016.  I didn't think that anything other than a columnstore index was supported.  Am I incorrect about this, and if so, could I be pointed to some documentation.  I can't find anything via google.
    Thursday, July 26, 2018 1:42 PM


All replies

  • Probably he meant that  he/she created a columnstore index on the table. You are correct .....

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Marked as answer by farslayer9 Thursday, July 26, 2018 2:37 PM
    Thursday, July 26, 2018 1:50 PM
  • It depends on how you look at things. If you ignore columnstore for a while:

    The rows (data) for a table can be a heap or it can be the clustered (row) index. If you are with me on this, then it is easy to expand:

    As of SQL Server 2014, you can also have a clustered columnstoe index. This means that the actual data is stored column-wise. So, in essence the data can nowadays be stored in three different ways: heap, row clustered and column clustered. The latter might have been what they meant by a "columnstore table".

    Or, perhaps, as Uri suggested, just a row-table with a non-clustered columnstore table?

    Tibor Karaszi, SQL Server MVP (Web Blog)

    Monday, August 6, 2018 7:45 AM