That was just what I was thinking. This approach will have the same issues that materialized views have as well

haha. We had a good internal debate as to whether this is more like indexes or more like Materialized Views. It's kinda a mixture of the two.