Nor more than a mention of Query Hints, which had some interesting discussion under a similarly-titled submission.

https://news.ycombinator.com/item?id=48413655