CD - efficient pruning is when the number of partition scanned is way lower than the total number of partitions so if you compare the two you can telle if your pruning is efficient or not.
"The efficiency of pruning can be observed by comparing Partitions scanned and Partitions total statistics in the TableScan operators. If the former is a small fraction of the latter, pruning is efficient. If not, the pruning did not have an effect."
https://docs.snowflake.com/en/user-guide/ui-query-profile#inefficient-pruning
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MatthieuDN
2 months, 4 weeks agoJacobr5000
4 months, 4 weeks agonexerSnow
7 months, 1 week agoicegrandpa
7 months, 1 week ago