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.

https://asktom.oracle.com/

Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit

Видео Materialized Views and More SQL Stuff канала Oracle Developers