QuestionQ22Verified/Monitor and optimize an analytics solutionCopy linkReport a problemAsk AstroTutorSave questionWhat should you do to improve the query experience for the business users?AEnable V-Order.BCreate and update statistics.CRun the VACUUM command.DIntroduce primary keys.Show AnswerAnswerExplanationV-Order optimizes Warehouse Parquet files for faster analytical reads by applying sorting and compression. Because the gold-layer warehouse has V-Order disabled while business users run ad-hoc queries against it, enabling V-Order improves the read performance that those queries rely on.Learn morePerformance Guidelines - Microsoft FabricDisable V-Order on Warehouse - Microsoft FabricShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion