Does something similar to Oracle’s optimizer hints exist in SQL Server ?
In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc… Does something similar exist in Microsoft Sql Server ?

Answer Question   |  April 19, 2009  8:59 PM
Microsoft SQL Server, Optimizer, Oracle, SQL, SQL Server, SQL tuning