Materialized views in oracle - Part 1 

No need to change the explaining style, the way you explained is great 👍

Just what I needed to understand the concept and why we need materialized views. Thank you.

You should be proud of yourself being so elaborate in your videos as u have mentioned in the end of this vdo. Very well explained in a polished to the point way.

Don't change your style of explaining things...this is the reason why i like your videos...keep doing the gr8 job!!!

Such clean examples, Thank you so much sir :)

The Best so far.. True Knowledge Sharing.. Thank You!!

Thanks! Video is extremely helpful to get a complete picture of Materialized view... And you are explaining well enough, please continue to share...

Fantastic Explanation, Thank you so much for your great effort for making this videos. it greatly helps us to understand things

U explained it very well like a Class 1 teacher explaining it to students...keep it up

Excellent! Thanks!

Really appreciate the effort. Keep continue your good work

just what i needed!!

Precise explanation. Appreciate the effort for coming up with real time scenarios.

Great explanation. Very helpful. Thank you and keep it up.

Really amazing explanation skills and provided superb content. The way you explain is really appreciated.

Lot of videos are available but this one is useful and unique one.

it's gud explanation, understood about view and materialized view diferences ,please proceed for remaining topics in oracle

Thanks Vivek, you are doing a great help to understand Oracle in a better way. Expecting videos On Architecture and Performance once you are done with your planned topics to make videos for. Take your time friend.. will be following you.. Thanks.. God bless you.

excellent explanation

Thanks Vivek :) your explanation are to the point . Keep doing the good work. Thanks for educating us .!!

your explanation style is correct.. be as it is :)

Excellent

Really apprciate the effort and way of explaination

Thanks a lot Vivek.... Really appreciate it :)

Great video!! Thank you so much.

Superb

It improve my understanding on MV

I like the way you tech and explaining the thing. please don’t the change the style. You the awesome and everyone will adapt your style!!

Very useful .. Thanks

Hi bro..your expalnation is very weel done..thank for sharing your knowledge.. pls provide ..plsql concepts also..like cursors,ref cursors,proc,func,packages,collections,triggers bro..pls provide as soon as possible bro..your all videos are very help ful to all..keep sharing bro..thank you bro

Great explanation 👌 👍 👏 😀

Great tutorial!

excellent way of explanation 👍👍👍👍

YOU ARE THE BEST

Excellent videos..is it possible to share sqls used so that we can practice the tutorial

THANK YOU

Its Great :)

great video from a great man

very well explained

brother can you plese make a videos on MV logs,primary key mv,red only ,updatable,writeable MV

Good explanation it is not long full stuff keet it dont change

Well explained.. Thanks.. Can you please make videos on Indexes, PL/SQL Collection and records..

Hi Vivek...Thanks for clear explanations, Can I request you please to upload or tell us about "explain plan " in real time..to tune the query

thank's friend

Good work sir. I have subscribed :)

Hi could you tell me please.how we can do auto refresh of materialized view

Q1> When the refresh of materliazed view s going on and at the same time, if someone tries to query, will user get inconsitent data or null data? Q2>How the incremental change happens inside Oracle? Q3> Instead of complete refresh, should we just drop and recreate the materalized view? Would that be faster? Incremental Vs total refresh Vs Drop & Create Q4> Think of a real life scenario to implement materilaized view answers for them please

awesome..can u make videos on performance tuning and query optimization

Hey Vivek, Appreciate for your effort. But I was searching for the complete video for Oracle performance tuning but I got few incomplete videos in RU-vid. I would really requesting you to create a playlist dedicated on Oracle performance tuning. How much important will be the topic you will notice once you will upload those videos. I can help you on the topics that need to be covered. Below I have given the topics. 1.Oracle Database Architecture 2.Oracle Execution Plans/Explain Plans 3.Explain Plan Content 4.Indexes 5.Where Clause Processing 6.Sorts/Views/Sub-Query Processing You can add more topics on Performanc tuning videos whatever you feel important. Regards, Ranaj

Hi Vivek, Your way of explaining things is too good. Please upload more videos on Exceptions and performance tuning. Would love to clear some doubts through these videos. Thanks

WHAT IS MEANT BY VIRTUAL TABLE AND PHYSICAL TABLE

Wait!! ...why need to pause video for subscribing. It can be subscribed while running. ;) .... Btw I enjoyed your session. Its first time I watched your video. It is quite understandable ... Thanks for your great work. ..also Subscribed :)

How to partition materialise view.... can you make a video on this...

What are the monitoring views in oracle database

Why do we need a materialized view instead of a simple view

Pls give a reply to me