How can we improve Microsoft Azure SQL Data Warehouse ?

Support for updating statistics on a single partition

This would increase update statistics performance for users who are currently loading data into a single partition and updating statistics afterwards.

Otherwise with growing data size, updating statistics takes longer after every load.

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

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • David commented  ·   ·  Flag as inappropriate

    This is incremental statistics right? If so has been a feature since SQL Server 2014...

  • Neil Palmer commented  ·   ·  Flag as inappropriate

    Our statistics rebuilds now take longer than actually loading data. Really need some form of incremental statistics update by partition.

Feedback and Knowledge Base