Memory usage
The memory utilization to support the creation of SPM views is equal to that required of CTAS statements. Queries that rely on the sorted nature of SPM might require more memory to sort the unsorted records that are added after the materialized views were created.