From the course: Advanced SQL for Query Tuning and Performance Optimization
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Challenge: Generating a query execution plan - SQL Tutorial
From the course: Advanced SQL for Query Tuning and Performance Optimization
Challenge: Generating a query execution plan
“
(upbeat music) - [Instructor] In this challenge, we want to view a query plan. So imagine that you want to understand how a SQL Select statement is being mapped from a declarative statement to a procedural plan. How would you view the plan to execute the statement, select, ID, description, category code from products where category code in P17, R81 and U76.