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 = ROUND_ROBIN |
| 13 | + | , DISTRIBUTION = HASH([Volcker]) |
| 14 | ) | |
| 15 | ; |