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
Watch video Materialized Views and More SQL Stuff online without registration, duration hours minute second in high quality. This video was added by user Oracle Developers 26 September 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,599 once and liked it 79 people.