Materialized Views and More SQL Stuff

Held on September 13 2018
In this session Chris Saxon led an exploration through Oracle SQL that mostly looked at materialized views, with a brief discussion of full outer joins:
Highlights include:
01:30 - what is a materialized view; why do they exist; benefit comparing to saving summary data in a new table
refreshing an MV
06:30 - MV refresh options; when to use them
12:50 - fast refresh restrictions; analyzing issues using dbms_mview.explain_mview; updating MV log
27:00 - statement level refresh (12.2)
34:00 - how to do a "double outer" aka full join; adding a running count for duplicate rows with analytics
38:10 - updateable MV alternatives; DIY sharding & other issues of dealing with a large database.
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
asktom.oracle.com/
Oracle Developers portal: developer.oracle.com/
Sign up for an Oracle Cloud trial: cloud.oracle.com/en_US/tryit