Question
Marsh & McLinen
GB
Last activity: 9 May 2018 8:54 EDT
How to use Materialized views functionality from Oracle 12c DB in Pega ?
How to improve performance by using Materialized views instead of traditional views ?
Pegasystems Inc.
IN
Hi Narendra,
Materialized view would be used generally when we need to frequently query remote External DB.
Pega would not interact generally with External DB and table until external DB are mapped.
If you have data at external db then perhaps you have to create views yourself and the map it with PRPC.
Thanks,
Ujjwal
Pegasystems Inc.
AU
Technically, I don't see any challenges to create Materialized views to refer the tables. However, I don't see any reason for doing so.
Can you please justify the business reason for creating materialized view for internal tables?
Allianz Germany
DE
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.