1) They are useful to copy remote data locally, improving the performance of queries that would otherwise have to use database links.
2) If you have lots of similar complex queries that perform aggregation of data, you may get benefits by using a materialized view to aggregate the data once, then have the queries posted against the ready prepared data.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests