SQL Server and the Plan Guides, An easy way create and utilize!
Hi Guys! First of all I must say a big t hank you for the first five thousands visualizations of this my Blog . I am really very proud of it! Thank you so much! Today i will show you how to create a Plan Guide in order to resolve, for example, parameter sniffing issues . I hope you enjoy this post! Introduction It was November when we spoke about parameter sniffing (read here. ) We have seen that parameter sniffing is not necessary a bad thing. Parametrization sniffing, instead, could be a problem if your data is distribuited unevenly! Today for this first post of february I will show you a way to solve this problem through the creation of a Plan Guide However, before talking of Plan Guide, we do also a small summary about unevenly distributed data . Let's start! Recap about not evenly distribuited data Suppose we have two tables where we store our orders. OrdTes represents the header of the documents while OrdRig its rows. A document can have on...