A big query is running right now. The result of a batch mode hash join that spills to disk is streamed into a temp table using
select into. The query is showing wait types
HTREPARTITION occasionally. The query is not using columnstore indexes.
I'm quite sure that these wait types are normal for batch mode hash joins that spill to disk. I'm trying to understand what these wait types mean out of curiosity. Maybe this insight can help optimize the query or find problems. So what do these wait types mean and under what circumstances are they expected?
No columnstore indexes. I'm using the
left join ZeroRowCsTable on 0=1 trick to enable batch mode for row mode tables.