COF-C03 - Performance Optimization, Querying, and Transformation - Section 4.1
Use Query Profile and query history to analyse, troubleshoot, and interpret query performance.
Use Query Profile to read a query's execution plan: the operator tree, the most expensive nodes, partitions scanned versus total, and warnings such as bytes spilled to local or remote storage. Use the query history and the QUERY_HISTORY views to find slow or queued queries and interpret what is limiting performance.
Query Profilequery historyQUERY_HISTORYbytes spilledpartitions scanned
More in this domain
Back to all Performance Optimization, Querying, and Transformation objectives, or the COF-C03 cert hub.
Examworthy is not affiliated with or endorsed by Snowflake. Original, blueprint-aligned practice material only.