🔥 3-day streak
Snowflake SnowPro Core (COF-C03)84 / 148
Question 84 of 148
A data engineer notices a query joining an orders table (10 million rows) with a shipments table (12 million rows) is running far slower than expected. In the Query Profile, the engineer sees that a single Join operator outputs roughly 480 million rows, and a large amount of bytes are spilled to local and remote storage. The join condition uses only a partial key. What is the MOST likely cause of the performance problem revealed by the Query Profile?
Reviewed for accuracy · Report an issueNext question