When you're dealing with non-third normal form db schemas for performance reasons where materialized views won't provide the gains you need. That said, I've on

When you're dealing with non-third normal form db schemas for performance reasons where materialized views won't provide the gains you need. That said, I've only seen a need for them about 3 times in my career, but I imagine they're much more applicable in data warehousing scenarios.