Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hugo Kornelis Stairway to Columnstore Indexes Level 1: A First Look At Columnstore Indexes RE: Stairway To SQL Server Columnstore Indexes Level 1: A First Look At Columnstore Indexes

  • April 30, 2015 at 4:09 pm

    #1794876

    Vijay.Govindan (4/30/2015)

    Hi Hugo,

    You are welcome! Yes, I forgot about that, being read only limits its use in a Datawarehouse / ETL environment in our case. Thanks for the link, I will be sure to check it out.

    We just started deploying filtered indexes in some of our ETL tables to help speed up our nightly loads since we are still using 2008 R2. We've seen dramatic improvements and I wanted to compare the filtered indexes against the clustered columnstore indexes and see which is faster overall. Thanks for your prompt and courteous response!

    Vijay

    If you have a datawarehouse that uses table partitioning, then the read-only limitation becomes far less annoying, because you can use partiition switching to add new data without having to rebuild the entire columnstore index. This, too, will be covered in a later level.

    And yes, depending on data and workload, filtered tables can also help. There are often multiple solution available in SQL Server.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/