I don't really know much about how the blockchain and steem software operates behind the scenes, I imagine it is indexed in useful ways to allow nodes to run efficiently. Steemsql, by it's nature is a third party service and SQL is not inherently part of the BC structure - so it seems Steemsql might be a bit limited in comparison to what a full relational database version of the BC could be.

The index I am creating is more of an index in the sense that google indexes pages on the web, rather than in the context of a database index for performance - I'm just running a test of my script now on one of my servers - I might even get a full index kicked off tonight, but it depends on how much time and resources it's going to take as to whether i attempt that without any optimisations made.

fingers and toes crossed! thanks for your witness vote :)