Creating Materialized Views in PeopleTools

Materialized Views are views that are pre-resolved by the database and stored for later use. They have a physical existence inside the database.

We can use Materialized Views to improve poor performance of complex SQL Views. That complex view is pre-rendered once and is then managed by the database. Queries using that view retrieve data from that prerendered table instead of re-executing the slow, complex SQL.

Jump Ahead
Intro: 0:00
Materialized View Review 0:12
Example: 0:53
Create Materialized View: 1:54
Refresh Materialized View: 4:14
PeopleBooks: 5:36

PeopleTools Tech Tips: https://peopletoolstechtips.com/creat...

Production Notes:
A PT3 Production
Presenter: Randall Groncki
Camera Kid: Anjelica Groncki

Music: Vlad Gluschenko — Overseas
License: CC BY 3.0: https://creativecommons.org/licenses/...
   / @vladgluschenkomusic