CREATE TABLE [dbo].[factWebAnalytics_test](
    [WebAnalyticsId] [bigint] IDENTITY(1,1) NOT NULL,
    [MarketKey] [int] NOT NULL CONSTRAINT [DF_factWebAnalytics_test_MarketKey]  DEFAULT ((-1)),
    [SampleColumn] [decimal](18, 2) NULL,
 CONSTRAINT [PK_factWebAnalytics_test] PRIMARY KEY CLUSTERED
(
    [MarketKey] ASC,
    [WebAnalyticsId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)

INSERT INTO [dbo].[factWebAnalytics_test]
           ([MarketKey]
           ,[SampleColumn])
SELECT TOP 5000000
    1, CRYPT_GEN_RANDOM(8) + 1
FROM master..spt_values v1, master..spt_values v2, master..spt_values v3

INSERT INTO [dbo].[factWebAnalytics_test]
           ([MarketKey]
           ,[SampleColumn])
SELECT TOP 3000000
2, CRYPT_GEN_RANDOM(8) + 1
FROM master..spt_values v1, master..spt_values v2, master..spt_values v3

cREATE NONCLUSTERED COLUMNSTORE INDEX [CIDX_factWebAnalytics_test] ON [dbo].[factWebAnalytics_test]
(
    [WebAnalyticsId],
    [MarketKey],
    [SampleColumn]
)WITH (DROP_EXISTING = OFF)



SELECT [s].[name] AS "Statistic",
       [sp].*
FROM   [sys].[stats] AS [s]
       OUTER APPLY sys.dm_db_stats_properties ([s].[object_id], [s].[stats_id]) AS [sp]
WHERE  [s].[object_id] = OBJECT_ID(N'[dbo].[factWebAnalytics_test]');


UPDATE STATISTICS [dbo].[factWebAnalytics_test] [PK_factWebAnalytics_test] WITH SAMPLE 10000 ROWS


SELECT [s].[name] AS "Statistic",
       [sp].*
FROM   [sys].[stats] AS [s]
       OUTER APPLY sys.dm_db_stats_properties ([s].[object_id], [s].[stats_id]) AS [sp]
WHERE  [s].[object_id] = OBJECT_ID(N'[dbo].[factWebAnalytics_test]');