Oracle read rewrite function Overview

Alter session set query_rewrite_enabled = true;
 
Alter session set query_rewrite_integrity = enforced;
 
Create
 
Create materialized view my_all_objects_aggs
 
Build immediate
 
Refresh on commit
 
Enable query rewrite
 
As
 
Select owner, count (*) from my_all_objects group by owner
 
/
 
 
 
Analyze table my_all_objects_aggs compute statistics;
 
 
 
 
 
Set autot on
 
Set timing on
 
Select owner, count (*) from my_all_objects group by owner