How can we improve Microsoft Azure SQL Data Warehouse ?

sort a columnstore on CTAS/rebuild

Columnstores can eliminate segments based on the min/max vaules of a column.

For best performance, the data would need to be sorted by the users desired column, such as a date.

See - http://www.nikoport.com/2014/04/16/clustered-columnstore-indexes-part-29-data-loading-for-better-segment-elimination/

I'd love to see a syntax that looks something like the below (but without the need for creating a clustered index first)

with
(
DISTRIBUTION = hash ( [store] ),
clustered columnstore index (order by DateStamp)
)

4 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Neil Palmer shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base