How can we improve Microsoft Azure SQL Data Warehouse ?

Columnstore system generated stat should not be user_created=1

Create a simple columnstore table and look at sys.stats:

create table dbo.systemDefinedStatBug with (clustered columnstore index, distribution=round_robin)
as
select 1 as column1, 2 as column2;

select *
from sys.stats s
where s.object_id = object_id('dbo.systemDefinedStatBug')

Notice it has a system generated "statistic". It use to be that row was marked as user_created=0 so we could easily tell that's not a regular user created stat. But these days in SQL DW it says user_created=1 on this "stat". Please fix this bug.

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

We’ll send you updates on this idea

Greg Galloway shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

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

Feedback and Knowledge Base