Nice post. That covers it at a high level pretty well. Thank you.

it certainly isn't received wisdom.

Not only that, i think most people who do that, do so out of sheer ignorance. When i ask them for the reasons, they repeat non-trueisms about how the RDBMS does things.