O'Reilly logo

Oracle Database 12c The Complete Reference by Bob Bryla, Kevin Loney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image

CHAPTER26Using Materialized Views

To improve the performance of an application, you can make local copies of remote tables that use distributed data or create summary tables based on GROUP BY operations. Oracle provides materialized views to store copies of data or aggregations. Materialized views can be used to replicate all or part of a single table or to replicate the result of a query against multiple tables; the database can automatically refresh the replicated data at time intervals that you specify. In this chapter, you will learn about the general usage of materia44lized views, including their refresh strategies; this is followed by a ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required