Columnstore Indexes Unveiled


Right click “Save as…”

Slides (view online)
This talk describes a new data warehouse SQL query acceleration feature in Microsoft SQL Server code-named "Denali" based on a new type of index called the columnstore. This new index,combined with enhanced query processing features,improves data warehouse query performance by hundreds to thousands of times in some cases,and can routinely give a tenfold speedup for a broad range of decision support queries. We describe the fundamentals of column store technology,and how to create applications using it in "Denali". We also describe how you can migrate your existing decision support applications to this amazing new capability.
For more information, check out this course on Microsoft Virtual Academy:

Follow the discussion

  • Oops, something didn't work.

    Getting subscription
    Subscribe to this conversation

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.