mirror of
https://github.com/Microsoft/sql-server-samples.git
synced 2025-12-08 14:58:54 +00:00
9 lines
210 B
SQL
9 lines
210 B
SQL
-- CTAS statement to create Trip table with hashed distribution on DateID column
|
|
CREATE TABLE dbo.TripHashed
|
|
WITH
|
|
(
|
|
DISTRIBUTION = Hash(DateID),
|
|
CLUSTERED COLUMNSTORE INDEX
|
|
)
|
|
AS SELECT * FROM dbo.Trip;
|