Snowflake
SOL-C01 · Question #276
Using Snowsight, you observe a query with the following SQL: FROM LARGE_TABLE WHERE ID IN (SELECT ID FROM SMALL_TABLE WHERE CONDITION - SELECT The query is performing poorly. When examining the Query
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #276. The question stem and answer options stay visible for context.
Querying and Performance
Question
Using Snowsight, you observe a query with the following SQL:
FROM LARGE_TABLE WHERE ID IN (SELECT ID FROM SMALL_TABLE WHERE CONDITION
- SELECT The query is performing poorly. When examining the Query Profile in Snowsight, what
specific operator should you MOST closely inspect to identify potential bottlenecks?
Options
- AThe 'Tablescan' operator on
- BThe 'Join' operator (if the IN clause is optimized into a join).
- CThe 'Filter' operator on after the 'Tablescan'.
- DThe 'Result' operator, indicating final result set generation.
- EThe 'Aggregate' operator (if present in the inner query).
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Query Optimization#Snowsight Query Profile#Subqueries#Join Operations