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