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

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.

Contents