Materialized views can greatly increase performance because they have dedicated physical storage compared to normal view which are only virtual SQL. In materialized view you should basically have aggregated data like sum, count etc. and data granularity that would best suit your application. Mapping materialzed view and external tables is no different in pega. Only thing you have to consider is that during refresh of materialized view your view is locked and not available to the application.