- This event has passed.
Query Rewrite: The Supreme League of Materialized Views
June 16 @ 12:30 - 13:30Free
Materialized Views are very useful to increase the performance of frequently executed queries. In many database applications, Materialized Views are accessed directly using SQL. However, the use of Query Rewrite is much more elegant and flexible: The optimizer decides independently whether a suitable Materialized View can be used to accelerate the query. The goal is to be able to improve the performance of different queries with the smallest possible number of Materialized Views. Query Rewrite offers excellent possibilities for this.
Although Query Rewrite is available in Oracle databases for a long time, the feature is still unknown to many Oracle developers and database administrators, or it is not used due to its complexity. This presentation shows the power of Query Rewrite, how it is configured correctly, what has to be considered when creating Materialized Views and which new features have been introduced in versions 12.2, 18c, and 19c.
Speaker BIO: Dani Schnider
Senior Principal Consultant, Trivadis AG
Dani Schnider works as Senior Principal Consultant for Trivadis, a Swiss IT consulting company. He finished his studies in computer science at ETH Zurich in 1990. Since 1994, he is developing data models and applications with Oracle databases, 1997 mainly in data warehousing projects.
Most of his time he is doing jobs for customers in the design, data modeling, ETL development, architecture reviews, and performance optimization of Oracle data warehouses. He is a teacher for several Oracle training at Trivadis and co-author of the (German) books «Data Warehousing MIT Oracle – Business Intelligence in der Praxis» and «Data Warehouse Blueprints.