Correct Answer: A
At least one of the columns accessed by the query filter operation has on the order of 100,000 distinct values or more.
To determine the number of distinct values, you can use either of the following:
• Use APPROX_COUNT_DISTINCT to get the approximate number of distinct values:
SELECT APPROX_COUNT_DISTINCT(column1) FROM table1;
• Use COUNT(DISTINCT <col_name>) to get the actual number of distinct values:
SELECT COUNT(DISTINCT c1), COUNT(DISTINCT c2) FROM test_table;
Correct Answer should be A
"At least one of the columns accessed by the query filter operation has on the order of 100,000 distinct values or more."
https://docs.snowflake.com/en/user-guide/search-optimization/queries-that-benefit
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.
MSIDDIQUI18
1 month, 1 week agoakellaanurag
1 month, 4 weeks agocui_li
9 months, 1 week agoAtomic_Gecko
9 months, 3 weeks ago