Using owb 126.96.36.199 and takes a long time to see any materialized view definition which is based on a particular table (talking a few minutes compared to over a minute compared to seconds
to see other mview definitions.
8 million rows in base table.
Thoughts as to why this would be case?
post actual EXPLAIN PLAN
db take long time to show definition of materialized view or data stored on it?
Or is the creation/refresh of materialized view slow?