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 ?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!