All Questions

Filter by
Sorted by
Tagged with
1
vote
2answers
153 views

Why does a many to one merge join change the sort order of the data set?

I have a query that calculates row_Number(). The table has a clustered index on the same columns (and order) as the partitioning and ordering for the row number. When using a merge join (many to one),...
1
vote
1answer
138 views

How to achive a many to one merge join in Azure Data Warehouse

I have a merge join in azure data warehouse. My estimated execution plan currently shows it as a many to many join. I'd like to know if it is possible to achieve a many to one join. Currently I'm ...
0
votes
0answers
34 views

Are clustered indexes in Azure data warehouse ever a good idea on large tables?

Azure data warehouse supports both clustered and non-clustered indexes in addition to columnstore (which is the default for any new table). I know that having a large clustering key is normally ...
1
vote
1answer
31 views

How to index cube style queries with changing aggrigations

I've got a query that emulates the CUBE function. This is many different aggregations unioned together. select x,y,z, sum(a) from tbl group by x,y,z union all select x,'all',z, sum(a) from tbl group ...