Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works. Database ...

We define the search space for a given query as the set of all the possible execution plans for that query, and any possible plan in this search space returns the same results. As discussed, the basic ...