Interview Questions
1. What is a query plan and what is the value from a performance tuning perspective?
A query plan is the physical break down of the code being passed to the SQL Server optimizer. The value from a performance
tuning perspective is that each component of the query can be understood and the percentage of resource utilization can be
determined at a micro level. As query tuning is being conducted, the detailed metrics can be reviewed to compare the
individual coding techniques to determine the best alternative.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment