View difference between Paste ID: F5eZWjSJ and 0fDUXeir
SHOW: | | - or go back to the newest paste.
1
CREATE TABLE [dbo].[BusinessHierarchies](
2
	[BookId] [nvarchar](250)	,
3
	[Division] [nvarchar](100)	,
4
	[Cluster] [nvarchar](100)	,
5
	[Desk] [nvarchar](100)		,
6
	[Book] [nvarchar](100)		,
7
	[Volcker] [nvarchar](100)	,
8
	[Region] [nvarchar](100)	
9
)
10
WITH
11
(
12
	CLUSTERED COLUMSTORE INDEX
13-
,	DISTRIBUTION = REPLICATE
13+
,	DISTRIBUTION = ROUND_ROBIN
14
)
15
;