Clustered Index seek doesn’t guarantee optimal Query plan
I was working on removing duplicate indexes from a table. Before removing an index usually I check whether that index is used by any query or not, is there any index …
Read MoreTag: Clustered Index Seek
SQL Server Nested Loop Join Operator – Revisiting: Part2
Hi Geeks, Before moving ahead with something new on One operator a day series, I wanted discuss another scenario on SQL Server Nested Loop Join Operator. I recommend you to read my earlier …
Read MoreSQL Server Key Lookup Operator – Part 2
Hi Geeks, I hope you liked yesterday’s post SQL Server Key Lookup operator Part1. Today, we are going to decode query plan in text and xml then find out if this operator appears anything different …
Read MoreSQL Server Clustered index scan vs Clustered index seek
Dear Friends, Yesterday and day before we have covered Clustered Index Seek and Clustered index Scan. In today’s post, let us draw a comparison between SQL Server clustered index scan vs clustered …
Read MoreSQL Server Clustered Index Seek Operator
Hi Friends, Let us look at Clustered Index Seek operator today. The statement below shows an example of SQL Server Index Seek (clustered) and of course database is our dearest AdventureWorks2012. SELECT …
Read MoreSQL Server execution plan – Simplifying : Part 11
Hi Friends, While checking SQL Server execution plans over last few weeks on this series; you would have seen these terms quite frequently; Actual Rebinds / Estimated Rebinds Actual Rewind/ Estimated …
Read MoreSQL Server Execution Plan – Simplifying : Part 10
Hi Friends, In last two blog posts of this series Part 8 and Part 9 I’ve explained SQL Server execution plan using INSERT, UPDATE statements. You guessed it right; today we would cover …
Read MoreSQL Server Execution Plan – Simplifying : Part 9
Dear Friends, In my previous blog post, Part 8 of this series we analyzed SQL Server execution plan using INSERT statement. Today, we will try UPDATE statement followed by explanations. Let us …
Read MoreSQL Server Execution Plan – Simplifying : Part 8
Dear Friends, SQL Server engine generates SQL Server execution plan for all SQL queries in order to figure out best path of execution when we submit any request. In my previous …
Read MoreSQL Server Execution Plan – Simplifying : Part 7
Hi Friends, In my previous blog post Part 6 on this series we saw how SQL Server execution plan changes when we use ORDER BY clause in SELECT statements. Today, we …
Read More