Skip to Main Content

having a mismatch between querying data and MV refresh

Hans LangenbergNov 4 2020

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,

HansL

Comments
Post Details
Added on Nov 4 2020
6 comments
5 views