SQL Server 2014 CPT1中的列存储索引改进是否已添加到SQL Server 2012? [英] Columnstore index improvements in SQL Server 2014 CPT1 added to SQL Server 2012?
问题描述
SQL Server 2014 CPT1中的Columnstore索引改进是否会作为Service Pack添加到SQL Server 2012?特别是批处理模式的改进。我们最近刚刚在过去几个月内升级到SQL Server 2012.
此博客文章中使用的语言表明它不会添加到SQL Server 2012.(但您可以随时在Connect上请求它。)
短引号:"在SQL Server 2012中,任何想要利用这个新索引并且还希望更新其背后的数据的人都必须放弃索引并更新数据,对列存储索引
和包含更改数据的常规行存储执行一些分区切换或联合查询。 这些变通办法不再需要
SQL Server 2014 因为我们有
将列存储增强为纯色列存储,因此不再需要索引.. "
RLF
Will the Columnstore index improvements featured in SQL Server 2014 CPT1 be added as a service pack to SQL Server 2012? Specifically the batch mode improvements. We just recently upgraded to SQL Server 2012 within the last few months.
The language used in this blog post suggests that it will not be added to SQL Server 2012. (But you can always request it on Connect.)
Short quote: "In SQL Server 2012, anyone wanting to take advantage of a this new index and also wanting to update the data behind it had to either drop the index and update the data, do some partition switching or unioning queries to the columnstore index and a regular row store containing the changing data. These workarounds are no longer required in SQL Server 2014 as we have enhanced the columnstore to be a pure columnar store, so indexing is no longer required.."
RLF
这篇关于SQL Server 2014 CPT1中的列存储索引改进是否已添加到SQL Server 2012?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!