Question
Why should a developer examine a query execution plan?
Select an option. Your answer will be checked instantly.
Correct Answer: B. To understand chosen access methods, joins, estimates, and expensive operators
Explanation:
The plan shows how the optimizer intends to execute the SQL statement.
It helps identify scans, bad estimates, spills, and missing access paths.
Leave a Reply