I totally agree that it is not possible to apply query hints to views inside the view. It will give you an error. However, there is a workaround.
Let us see a very simple script today. It is about Altering Column – From NULL to NOT NULL. Comprehensive Database Performance Health Check
After reading it, lots of people asked me if I can make a video on this topic. Of course, here we go, Read Only Tables – Is it Possible?
Well, the answer is pretty straight forward and that is what we are going to see in today’s video of One Scan for 3 Count Sum.