119 questions for “Query Optimization & Plans”

Found in 1 field. Select a question to see its full answer.

Matching topics

SQL Server Query Optimization & Plans 7 SQL Server Query Store 5 SQL Server XML Data Type & Querying 3

Information Technology

119 questions in 1 technology

#QuestionTechnologyTopicLevel
1What is an execution plan in SQL Server, and how does it help you understand query performance? SQL Server › Query Optimization & PlansSQL ServerQuery Optimization & PlansBeginner
2How do outdated or missing statistics affect the query optimizer's ability to choose an efficient execution plan? SQL Server › Query Optimization & PlansSQL ServerQuery Optimization & PlansIntermediate
3What is parameter sniffing, and how can it sometimes lead to unexpectedly poor query performance? SQL Server › Query Optimization & PlansSQL ServerQuery Optimization & PlansIntermediate
4How do you use the SQL Server Query Store feature to identify and address query performance regressions over time? SQL Server › Query Optimization & PlansSQL ServerQuery Optimization & PlansAdvanced
5What are the most common causes of poor query performance that you should check first when troubleshooting a slow query? SQL Server › Query Optimization & PlansSQL ServerQuery Optimization & PlansIntermediate
6How would you use query hints to influence the optimizer's behavior when you have determined the default execution plan is genuinely suboptimal? SQL Server › Query Optimization & PlansSQL ServerQuery Optimization & PlansAdvanced
7What is the difference between a table scan and an index seek in an execution plan, and why does this distinction matter for performance? SQL Server › Query Optimization & PlansSQL ServerQuery Optimization & PlansBeginner
8What is Query Store in SQL Server, and what information does it automatically capture? SQL Server › Query StoreSQL ServerQuery StoreBeginner
9How do you view the top resource consuming queries captured by Query Store? SQL Server › Query StoreSQL ServerQuery StoreBeginner
10How do you use Query Store to identify a query whose performance has regressed after a recent code deployment? SQL Server › Query StoreSQL ServerQuery StoreIntermediate
Show all 119 questions in Information Technology