ETL9.2: Direction On Handling Materialized Views For MS SQL Server
(Doc ID 2663311.1)
Last updated on JULY 22, 2020
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, Technical
Direction on handling Materialized Views for MS SQL Server
We are exploring using delivered Materialized Views PS_TL_CALPYESEL_VW for MS SQL Server, currently it is summary table (Physical Tables without refresh data), any recommendations for this materialized view? How often to refresh this materialized view?
SQL Server has options to change the physical summary table to indexed view (materialized view, data refreshed automatically), any concerns to use Indexed view?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document