![]() ![]() Select a, count_big(distinct b) from t group by a A SELECT query with COUNT_BIG( DISTINCT expression) took multiple seconds to complete and it reads data directly from the base table a. Insert into t select a + 1, b + 2, c + 3 from t Create table t(a int not null, b int not null, c int not null) with(distribution = hash(a), clustered columnstore index)
0 Comments
Leave a Reply. |