Thus far, a compelling case has been presented to separate OLTP and OLAP workloads into unique data structures and optimize each for their respective use cases. Columnstore indexes are an SQL Server feature that provides native support for large analytic data. This chapter will dive into what they are and why they are an effective solution to analytic data challenges.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

What Are Columnstore Indexes?

  • Edward Pollack

摘要

Thus far, a compelling case has been presented to separate OLTP and OLAP workloads into unique data structures and optimize each for their respective use cases. Columnstore indexes are an SQL Server feature that provides native support for large analytic data. This chapter will dive into what they are and why they are an effective solution to analytic data challenges.