You can have multiple small materialised views, which get updated when appropriate and are composed by a regular view. It’s more convenient than a single large

You can have multiple small materialised views, which get updated when appropriate and are composed by a regular view. It’s more convenient than a single large materialised view.