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 26 Сентябрь 2018, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,599 раз и оно понравилось 79 людям.