Which common query issues can be identified by the Query Profile? (Choose two.)
Which common query issues can be identified by the Query Profile? (Choose two.)
Query Profile typically helps identify inefficient query pruning and exploding joins. Inefficient query pruning occurs when queries are not efficiently reducing the dataset early in the execution plan, which can lead to unnecessary processing. Exploding joins happen when a join operation significantly increases the number of rows, leading to performance issues.
"Common Query Problems Identified by Query Profile: 'Exploding' Joins, UNION Without ALL, Queries Too Large to Fit in Memory, Inefficient Pruning, and Query Profile Data Redacted from a Snowflake Native App"
It's B D : https://docs.snowflake.com/en/user-guide/ui-query-profile#common-query-problems-identified-by-query-profile