Does someone has experience with Materialized Views?
I am new to this and have created such views for some queries (response time > 60 sec). Issue is: MV works well right after it is created and we get very good response time (< 10 sec). But if query is performed after sometime (say ~3 hrs later) it goes back to bad performance.
MV has been created with ENABLE QUERY REWRITE option.
Appreciate any help.
I am new to this and have created such views for some queries (response time > 60 sec). Issue is: MV works well right after it is created and we get very good response time (< 10 sec). But if query is performed after sometime (say ~3 hrs later) it goes back to bad performance.
MV has been created with ENABLE QUERY REWRITE option.
Appreciate any help.
