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 […]