April 21, 2020 at 1:37 pm
If I have a 500 million rows PAGE compressed table,
should I/Can I be creating a Columnstore index on such compressed table? Will it even work?
Will it be beneficial.. ?
Can't find much on web on correlation between regular data compression and Columnstore compression.
thanks.
Likes to play Chess
April 21, 2020 at 2:34 pm
should I/Can I be creating a Columnstore index on such compressed table? Will it even work?
Test it - easy enough for you to create a table with normal compression and then create a columnstore index on it - no need to ask anyone if it will work as you can do it yourself
Will it be beneficial.. ?
Maybe - as usual it depends - test test test - and have a search on this forum for recent threads regarding columnstore which will give you some ideas.
regarding data vs columnstore - again there are no rules - some compress more, other compress less - again it depends.
you can and should however read this series of articles from Nico Neugebauer - both available here and on http://www.nikoport.com/columnstore/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply