June 6, 2012 at 11:24 pm
Hi All,
How it will works?
As per my understanding the only the particular column data will be fit into a single page, here is my doubt:
Suppose If we have supplier table and we have Non-Clustered index (Not column store index) on Suppliername (the index is B-Tree having the Supplire name as Index Keys, and leaf level will contain the pointer to Clustered key)
How about if we create COLUMNSTORE index on SupplierName (How the index page will be?)?
Please clarify my very basic doubt.
Thank you,
🙂
June 6, 2012 at 11:45 pm
1) there is no column store index with SQL2005 !
2) SQL2012 column store indexes turn your table in read-only mode !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 6, 2012 at 11:50 pm
SQL* (6/6/2012)
How about if we create COLUMNSTORE index on SupplierName (How the index page will be?)
See http://rusanu.com/2012/05/29/inside-the-sql-server-2012-columnstore-indexes/
June 7, 2012 at 12:01 am
SQL* (6/6/2012)
How about if we create COLUMNSTORE index on SupplierName (How the index page will be?)?
The index part in the name columnstore index can be a bit misleading. It doesn't really function like an index we already know. Instead, it stores the entire columns included in the index in segments of 1 millions rows and highly compresses them.
When you read a column of this index, only the needed segments are read and put into memory. In other words, there is no such thing as an index seek with this type of index, only scans of one or more segments.
The article Paul provided is a very excellent one and I truly recommend reading it. It has some great references at the bottom.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply