3 ms·
Do you know of any good resources to understand sql explain plan. In my current project, we are facing a lot of issues related to query performance on MS SQL se
by hi41 3y ago
Do you know of any good resources to understand sql explain plan. In my current project, we are facing a lot of issues related to query performance on MS SQL server. Do we need to always specify index hint with queries. Sometimes index exists but query does not seem to be using the index. I am thinking using sql execution plan could help us understand this issue better. tia.
- cocoflunchy 3y agoI recommend https://use-the-index-luke.com/ https://use-the-index-luke.com/ or even better do the training with Markus Winand, it'll change how you view databases.
- otar 3y agoI was recommended this video once, but I haven't watched it: https://youtu.be/sGkSOvuaPs4 https://youtu.be/sGkSOvuaPs4 Use the Index Luke (also recommended by cocoflunchy) was one of my go to resources once. Also, Tobias Petry does a really good job by covering many advanced topics on a Twitter and his books: https://twitter.com/tobias_petry https://twitter.com/tobias_petry