1

i'm learning how to use columnstore in sql server and i can't figure out how it works. this is a normale rowstore sample: rowstore

If we use columnstore it should look soemthing like this according to this article : columnstore

now how is it possible to retrieve ross taylor info if the order is not preserved in the columnstore format?

bakaou baka
  • 37
  • 7
  • consider reading this, as I learnt from here: https://logicalread.com/sql-server-columnstore-index-w02/ – Prabhat G Feb 27 '18 at 10:06
  • @PrabhatG I have already read it. same issue i don't undestand how jose chincilla info can be retrived if they are not in the same order in the data pages. like jose name is 4th and last name is 1st. how can you link it back. – bakaou baka Feb 27 '18 at 10:15
  • Niko Neugebauer has so much in-depth information about column store indexes and you should check out [his blog](http://www.nikoport.com/columnstore/). Your question's answer can be found in [this article](http://www.nikoport.com/2014/10/23/clustered-columnstore-indexes-part-42-materialisation/). It is explained how the materialisation is done, how the data is stored in dictionaries to achieve compression and how to read it back. – Rigerta Feb 27 '18 at 10:31
  • I have read the article you gave @RigertaDemiri . it talks about how to use dictionnaries to use less space for redundant values. but even in his article to materialize the original colum the substitute column used with the dictionnary has the same order. while in my question the order is not preserved. – bakaou baka Feb 27 '18 at 11:02

0 Answers0