QuestionQ97Verified/Performance Optimization, Querying & TransformationCopy linkReport a problemAsk AstroTutorSave questionHow can a user determine whether a micro-partition is being pruned efficiently?ABy inspecting the statistics pane in the Query ProfileBBy inspecting the query details output in SnowsightCBy using the SYSTEM$CLUSTERING_INFORMATION() functionDBy querying the INFORMATION_SCHEMA.TABLES viewShow AnswerAnswerExplanationEfficient micro-partition pruning is indicated in the Query Profile’s TableScan statistics when Partitions scanned is a small fraction of Partitions total. This shows that the query avoided scanning unnecessary micro-partitions.Learn moreMonitor query activity with Query HistoryShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion