Well thought-out and illustrated Jason, thanks! 😎
So should we always check queries returning just a few rows to see if a forced Nested Loop would help?
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking