Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS dbo.CCI;
- CREATE TABLE dbo.CCI (ID BIGINT NOT NULL, INDEX ICCI CLUSTERED COLUMNSTORE);
- INSERT INTO dbo.CCI WITH (TABLOCKX)
- SELECT TOP (1048576)
- ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) RN
- FROM master..spt_values t1
- CROSS JOIN master..spt_values t2
- OPTION (MAXDOP 1);
- DBCC TRACEON (3604);
- DECLARE
- @DBID SMALLINT = DB_ID(),
- @partition_id BIGINT =
- (
- SELECT
- CSS.[partition_id]
- FROM sys.partitions AS P
- JOIN sys.column_store_segments AS CSS
- ON CSS.[partition_id] = P.[partition_id]
- WHERE
- P.[object_id] = OBJECT_ID(N'dbo.CCI', N'U')
- )
- DBCC CSINDEX
- (
- @DBID,
- @partition_id,
- 2, -- column id
- 0, -- segment_id
- 1, -- 1 = segment
- 0 -- print option
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement