This figure illustrates how materialized views work with the SQL Access Advisor: