- 3,714,738 Users
- 2,242,615 Discussions
- 7,845,038 Comments
having a mismatch between querying data and MV refresh
Hi, Having a question.
We have a question about a Materialized View request.
We have a MV, and the query defining it is complex.
But when i run the query it takes seconds to give me all the rows, when i use the query to fill a "normal" table it take about twice the amount of time. But when i do a refresh of the MV it takes almost 10 minutes. (being hours on production with full data set)
Our database version is 12.1
The insert of the refresh holds the following hint:
/*+ BYPASS_RECURSIVE_CHECK APPEND */
TIA for any idea that might help to solve this problem,