The same optimizations could be done inside the blockchain nodes code (steemd/hived).
It's just that it's easier to replace it with a centralized DB, and shutting the door to the decentralized option because of 'optimization'.
It's the wrong approach, and with a bit of reasoning you would come to the same conclusion, unless you'd rather stay blind and happy about how things run.