@nitinkhanna WordPress isn’t interested in speed. I’ve offered many database optimizations over the years and they choose to let things go the way they are, as it encourages a cottage industry of semi-competent pattern recognizers to call themselves a “WordPress Expert” and charge consulting fees to do X, Y, and Z things that could really be part of the core.
That said, if speed is what you’re after, perhaps Redis could help? WordPress’ database is used mostly as a Key-Value store, which makes a Redis intermediary layer a logical caching tool 🤔