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