In Chapter 2, I showed how the query optimizer processes a SQL statement to produce a physical query plan. You will investigate how the query profiler operates by executing a query plan and generating execution statistics that expose various metrics.
This chapter initially focuses on the visual aspects of query profiling and later focuses on remediating issues.
The hands-on examples utilize TPC-H data supplied by Snowflake; you can find additional information about this data set at https://docs.snowflake.com/en/user-guide/sample-data-tpch ...