How can we improve Microsoft Azure SQL Data Warehouse ?

Support rebuilding DW indexes with Online = ON so the table is accessible during the rebuild

This works:
ALTER INDEX ALL ON VulnerabilityScope REBUILD
But, when the rebuild takes place, the entire table becomes locked from any query--even selecting one row. Users complain when the table is inaccessible during the 30 minute rebuild.

This currently returns an error:
ALTER INDEX ALL ON VulnerabilityScope REBUILD WITH (ONLINE = ON)
Parse error at line: 1, column: 48: Incorrect syntax near 'ONLINE'.

Please support rebuilding DW indexes with Online = ON

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

We’ll send you updates on this idea

Marty Piecyk shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
under review  ·  AdminSQL DW Team (Feedback, Microsoft Azure) responded  · 

Thank you for the feedback folks. For now, you can use Alter Index reorganize as the online operation when rebuilding your CCI . We will reach out when this is on our roadmap. Please describe your scenario for this capability below and continue to vote. Thanks for your patience.

1 comment

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

    By the way, even queries with NO LOCK get stuck until the rebuild is complete:
    SELECT TOP 1 * FROM VulnerabilityScope WITH (NOLOCK)

    And, as expected, this results in an error:
    ALTER INDEX ALL ON VulnerabilityScope REBUILD WITH (NOLOCK)

Feedback and Knowledge Base