• SQL!$@w$0ME - Monday, May 22, 2017 12:35 PM

    Hello Folks,

    How do you perform/schedule index maintenance on Azure Data warehouse. Is there an option to view index fragmentation details like in SQL Server using sys.dm_db_index_physical_stats?
    Many thanks!

    To be honest, I probably wouldn't bother. With the data distributed, possibly partitioned and spread out across all the nodes, fragmentation probably isn't a huge concern.
    You MUST update statistics manually (and create them manually too). The control node does not create or update statistics automatically and it having correct statistics is critically important to get good distributed plans.

    Are you using mostly columnstore indexes, as is the recommendation I've seen a lot, or rowstore clustered indexes?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass