SQL SERVER 2012 COLUMNSTORE INDEX-之二

来源：未知责任编辑：责任编辑发表时间:2013-11-18 20:57　点击:次

前文简单介绍了CLOUMNSTORE INDEX, 现在来看一个例子.

首先, 需要一个比较大的表

3千多万行.

下面, 来比较 NONCLUSTERED INDEX 和 COLUMNSTORE INDEX

NONCLUSTERED INDEX 的

SQL Server Execution Times:

CPU time = 3027 ms, elapsed time = 20397 ms.

SQL Server parse and compile time:

CPU time = 0 ms, elapsed time = 0 ms.

SQL Server Execution Times: www.2cto.com

CPU time = 0 ms, elapsed time = 0 ms.

COLUMNSTORE INDEX 的

SQL Server Execution Times:

CPU time = 1855 ms, elapsed time = 2104 ms.

SQL Server parse and compile time:

CPU time = 0 ms, elapsed time = 0 ms.

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 0 ms.

注意看:

COLUMNSTORE INDEX 的 MODE : BATCH.

作者 incognito007