SQL SERVER 2012 COLUMNSTORE INDEX - 之二

前文简单介绍了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:
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.