In MS SQL Server current versions will work with the hint?

Just learning sql server since version 2012. Know that hints were needed in older versions, new optimizer like myself to be able to choose the optimal plan. Or, is there a sense to learn how to use the hint in the new versions of 2012+ ?
July 8th 19 at 12:17
1 answer
July 8th 19 at 12:19
The query optimizer in SQL Server is very smart and copes well with assigned tasks. It makes sense to learn how to use the hint when you have an ultra complex query to select from the very large database, and you can see that the optimizer is obviously unable to cope, and here in this place here can better be done.
If you are just starting, concentrate on more important things. The book Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 to help you is a very good material for learning.

Find more questions by tags SQL Server