Forcing an Index for a query

As we know that SQL Server Optimizer always finds out the “best” plan possible within the given time frame. There could be some use cases when you need to force an index to be used by SQL Server, I have done this many a times to study the actual reason why some specific Index is […]

Indexing Fundamentals: Indexing for Joins

Follow the below guidelines as a reference for creating Indexes for queries having JOINs. Single JOIN Generally the smaller table is hit first when there is no WHERE Clause Single JOIN with WHERE When comibing JOIN with WHERE  think of JOIN like a Where only. Better to break the join and WHERE and improve the […]