Enhancing Life Science Research

BLOG

Categories

Posts tagged materialized view logs

How to create an Oracle materialized view that performs well on fast refresh ?

How to create an Oracle materialized view that performs well on fast refresh ?

If you’re struggling setting up Oracle materialized view that performs well on fast refresh, you may find answers in this post!

TechSébastien ConilleauAugust 10, 2020Materialized view, Fast refresh, Performance, ORA-12004, ORA-12015, slow refresh, materialized view logs, Oracle, Ansi join notation, outter join Comments