My Oracle Support Banner

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.

Goal

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?
 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.