refresh materialize view takes a lot of time
when refreshing materialized view - it takes 11 hours but select from underlined view takes about 20seconds, the INSERT /*+ BYPASS_RECURSIVE_CHECK */
INTO my_mat_view takes forever
Tried atomic_refresh => FALSE but it does not help
Oracle database 19.33
Any ideas?