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: Non-clustered Index Seek
SQL Server Key Lookup Operator – Part 4
Hi Geeks, Last three days we have been discussing on SQL Server Key Lookup operators and if you are reading this post ahead of them, I recommend you to read Part1 , …
Read MoreSQL Server Key Lookup Operator– Part 1
Hi Friends, Continuing from yesterday’s post on Non-clustered Index seek operation, obvious question is what happens if non clustered index does not contain all columns requested by statement(s)? To find an …
Read MoreSQL Server Index Seek Nonclustered
Hi Geeks, SQL Server index seek nonclustered uses a non-clustered index to perform search operation. The statement below illustrate a non-clustered index seek operator. USE [AdventureWorks2012] SELECT Address.AddressID, Address.StateProvinceID FROM Person.Address …
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 MoreSQL Server Execution Plan – Simplifying : Part 6
Hi Friends, When we add some basic clauses to our queries, different operators are being displayed in the SQL Server execution plan. Today we will have a look when we introduce …
Read MoreSQL Server Execution Plan – Simplifying : Part 5
Hi Friends, I hope you are finding this series useful and read my previous posts Part1, Part2, Part3 and Part4 where I covered different operators. Today I’m going to talk about two …
Read More