Category Archives: Execution Plan

SQL Execution plan deep dive (05-Sort)

Note: This blog is continuation to earlier blog: SQL Execution plan deep dive (04-Spool) In this blog we will see how sort impacts the performance. Fundamentally sorting is used across most of execution plans and it works good with small … Continue reading

Posted in Execution Plan, SQL | Tagged , , , | Leave a comment

SQL Execution plan deep dive (04-Spool)

Note: This blog is continuation to earlier 3 blogs 1.       SQL Execution plan deep dive (01-Basics I) 2.       SQL Execution plan deep dive (02-Basics II) 3.       SQL Execution plan deep dive (03-Scan, Key Lookup) In simple terms spools are like storing the … Continue reading

Posted in Execution Plan, Performance, Productivity, SQL, Uncategorized | Tagged , , , | Leave a comment

SQL Execution plan deep dive (03-Scan, Key Lookup)

Note: This blog is continuation to earlier 2 blogs 1.       SQL Execution plan deep dive (01-Basics I) 2.       SQL Execution plan deep dive (02-Basics II) In the next few blogs, I will cover following topics which can be analyzed during … Continue reading

Posted in Execution Plan, knowledge, Performance, Productivity, SQL, SQL Server, Uncategorized | Tagged , , , , , | 1 Comment

SQL Execution plan deep dive (02-Basics II)

This blog is a continuation to SQL Execution plan deep dive (01-Basics I) which explains what an execution plan is and different execution plan components. How to view different execution plan details: Execution plan can be viewed in 3 different … Continue reading

Posted in Execution Plan, SQL, SQL Server, Uncategorized | Tagged , , , , | 2 Comments

SQL Execution plan deep dive (01-Basics I)

Majority of DBAs and Developers think about converting Scan into Seek after analyzing execution plan. This is a good start but is not sufficient to address most of the performance problems. I will start with basics in this blog and … Continue reading

Posted in Execution Plan, Performance, Productivity, SQL, SQL Server, Uncategorized | Tagged , , | 2 Comments