Column order and equality operator on Index
Does Column order in where clause matters? Whenever I have any doubt, I always play around with it to clarify my doubt. While doing experiment with index operation, I learnt something …
Read MoreTag: index seek
Index Selection Fundamental
Index is one of most widely discussed topic among developers and DBAs. During query optimization Index is one of the important aspects. I came across multiple instances where Developer/ DBA creates …
Read MoreClustered 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 MoreIndex seek vs Index scan in SQL Server
An index is a way to speed up performance of a query in SQL Server. An index is a B-Tree structure on a table column or set of columns referred as …
Read MoreSQL Server impact of different collation and query plan
Hi Friends, Recently I completed my blog series on execution plans which I hope helped you to understand on the basics. Couple of days back, I got a message in one …
Read MoreSQL Server Index Internals Part 2 – Why is the Optimizer SEEKING instead of SCANNING
Hi Friends, I had started the SQL Server index internal series sometime back. The first part is here; Apologies for making it late on Part 2 – this part is more …
Read More