Thanks, Walker! :D If you need up-to-the-second results, I'd stay away from a materialized view and go with a regular ol' view and generate results on the fly. In my experience, materialized views are best for things that don't change often.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.