Materialized View In Oracle - Part 3 

I have watched many videos on mv your explaination makes me to remember the basis for a longer time. Thanks for sharing knowledge

I feel back in college, Great explanation!!! I'm blown away by these materialized views Thanks for sharing your knowledge.

Hi Vivek, If you want to really educate the people like me who are really interested then please 1 humble request. Please create all videos for the specific topic and upload it finally by which we will get the complete information. I saw may cases that you posts are very useful and nice but it is incomplete. For example the post on oracle analytic function, materialize view which you want to describe DML operation on materialize view. Please upload the post at a time..it might take time but finally when it come to us it would work like a package of complete information. Regards, Ranaj

Thank u for such valuable videos. Could u please create a video specially on Query Rewrite. On what cases the query rewrite works and in which cases it does not work? Please explain with example. Request you to pause while explaining.

Vivek, Thanks a lot for detailed explanation. It is very useful during my interview preparation. I had a interview question on MV. 5 MV's are created on 5 different servers (all the MV query are same) and base tables on different server. All the 5 MV's are scheduled for FAST refresh by midnight. If one of the MV's is not available, then how the 'missed' MV will get refreshed? In FAST refresh, once the data is refreshed the MV log file will be cleared. In this case, since one of the MV is not updated yet, how the oracle will handle it? Another question is: does the refresh method uses pull or push mechanism? Can you help me on these questions?

Great explanation on this series. Thanks a lot!!

Complete refresh is happening and somebody tries to access mview what will happen - You havent discussed this point -> Data will be fetched from redo logs?

Can we create index on materialize view?? And please share your video of dml operation on materialize view as well

While complete Refresh the materialized view create exclusive locks on the Mview which is being truncated and inserted ? Creating lot many Mviews does not affect the memory space usage since it is a physically stored DB object?

Very nice explanation every time in your video.

Really helpful . I have view with nested view in it which are non materialized so would it be advisable to make all view materialized or only which are giving poor performance should be replaced ? Can we used non materialized view inside materialized view please reply .

Thanks Can you tell us how to refrech the data warehouse then with these materialised views please?

Can we do update or any dml operations in MV?

Can we alter the MV from on Demand to on commit refresh?

Is query rewrite supported in FAST refresh?

Outstanding explanation

Please add next video for materialized view

Thank you .. Well Explained 👍

waiting for next video bayya .......

Explained very well! 👌🏿

Do we need to commit in case of fast refresh?

Great video

thanks that was very helpful and easy to understand

Clearly explained.

Don’t say -please subscribe my channel, it sounds very cheap. You r a talented guy then y begging 🥺 for subscription.

Thank you so much for your information

Thanks for this video. Please give your patreon or create a community.

not clear

LOVE TO LISTEN U WITHOUT ANY BREAK....

Great video, as mentioned at the end of the video, Is there a part 4 video for DML operations on Materialized views? I don't see it in the channel.

Great explanation!

NIce explainations for all the videos, proved to be quiet helpful (Y)

Nicely explained ... Thanks a lot

Great video - thanks!