To (force)seek or not to (force)seek
Everybody does it, but nobody admits it. Forceseek is a forbidden word in the DBA world. In the world of experts, query hints should be the last resort for fixing performance issues. And is true, with a good data model, good code and good maintenance, the query optimizer should come up with a very good plan. But good data models are hard to come by in real life, good code gets bad in time and maintenance is but a dream…