Materialized views in oracle - Part 1

In this video I have explained what are materialized views?
What are there basic difference with views, and how they leverage query rewrite to optimize the performance with almost no change in existing code
#MaterializedView #OracleViews #TechCoach

[@jayeshpanigrahi8161]

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

[@TechCoach]

Thannks Jayesh for the kind words.
I have a small request, I am working on this new channel and will really appreciate if you watch and subscribe to it.
th-cam.com/video/IP2Vn6jK8Hg/w-d-xo.html

[@latestvideosnews]

@@TechCoach wow just bumped acroos this channel not sure why it is underrated seen many videos to understand my company project none better this one.

[@TechCoach]

@@latestvideosnews Thanks a lot buddy I am glad I could help :)

[@fashion22102008]

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

[@TechCoach]

Aditya Bohra Thanks Aditya for the kind feedback :)

[@arjunpalitphotography]

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.

[@TechCoach]

Thanks for the kind words Arjun.
I have a small request I am working on this new youtube channel "An Indian Abroad" ,it will really help me if you watch and subscribe to it.
th-cam.com/video/HBQHekM1U2c/w-d-xo.html

[@almaazfaaizza4675]

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

[@TechCoach]

Thanks a lot for the kind words :)

[@uditech7736]

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

[@TechCoach]

I am glad I could help :)

[@ShivaKumar-ps1vh]

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

[@TechCoach]

Thabks buddy

[@veeraiahsundarsetty4888]

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

[@TechCoach]

Sure, Thanks a lot of the kind words :)

[@Rizwan079]

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

[@TechCoach]

Thanks Mohammed Rasool for the kind words, there are 2 more vidoes on materialized views that may interest you :)

[@45_rickykumari75]

Great explanation 👌 👍 👏 😀

[@TechCoach]

Thanks a lot :)

[@lakshmipathiande2551]

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

[@TechCoach]

Thanks a lot for the kind words, your words made my day.

[@paravaiarasu6161]

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

[@TechCoach]

Thanks Buddy for the kind words :)

[@KalyanS]

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

[@TechCoach]

Thanks a lot buddy for the kind words :)

[@amol013]

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.

[@TechCoach]

Thanks for the blessings, I have noted these topics and I will try to explain them soon in future:)

[@saifali7080]

Such clean examples, Thank you so much sir :)

[@devanaidu9406]

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

[@TechCoach]

Thanks for the kind words. I shall try to make these videos soon.

[@devanaidu9406]

Hi bro..Good morning..thank you bro..we are always waiting for updates bro..have a nice time to you..

[@tejaswini3181]

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

[@TechCoach]

Thanks Tejaswini for the kind words :)

[@VinodKumar-cb2by]

@@TechCoach w3

[@TheShivmishra]

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

[@prashanthchandrashekar2929]

Did you get a response for these questions?

[@cmpsnehrunagar9754]

Superb

[@digvijaydamame7351]

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

[@TechCoach]

Thanks for the kind words

[@manjudatta2]

Very useful .. Thanks

[@TechCoach]

Thanks a lot Manju for the kind words :)

[@cibiruban2578]

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

[@TechCoach]

Thanks a lot for your kind words and Advice :)

[@pankajkharade6936]

excellent way of explanation 👍👍👍👍

[@TechCoach]

Thanks Pankaj for the kind words.

[@prashantmhatre9225]

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!!

[@TechCoach]

Thanks a lot for the kind words

[@TechCoach]

Thanks a lot for the kind words

[@chabrillon]

Excellent! Thanks!

[@shaileshsingh1445]

excellent explanation

[@ramanjineyulunanavala2236]

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

[@TechCoach]

Thanks Ram for the kind words I have a small request
I am working on this new youtube channel, I Would love it if you watch and subscribe to it as well.
th-cam.com/video/GnVn3mPBRz4/w-d-xo.html

[@prachichandrakar4753]

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

[@TechCoach]

Thanks prachi for the kind words, there are 2 more videos on materialized views post this one which may interest you as well.

[@ShubhangiiGopinath]

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

[@TechCoach]

Sure Shubhangi I will try to work on one, meanwhile you can lookup Ananya das on youtube he also has explained explain plan in a detailed way. I have a small request, I am working on this new channel and would really appreciate if you watch and subscribe to it.
th-cam.com/video/IP2Vn6jK8Hg/w-d-xo.html

[@arunrocketz]

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

[@TechCoach]

Sure Arun, Its next on my cards :)

[@arunrocketz]

@@TechCoach Thanks in Advance😊

[@ranajparida3902]

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 TH-cam.
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

[@TechCoach]

Sure buddy, I have videos on some of the topics, you can check them out. I will try to create videos on the remaining topics asap

[@ranajparida3902]

@@TechCoach can you please give the link for those videos.

[@TechCoach]

This series on Indexing can clear your basic concepts
th-cam.com/play/PLUWdEQb_2yqVXnx-P1881VVtec8moW1sk.html

[@deepaksrivastava4239]

Really apprciate the effort and way of explaination

[@TechCoach]

Thanks a for the kind words Vinit, I have a small request I am working on this new channel please do watch and subscribe to it.
Your support is my motivation.
th-cam.com/video/Oz4TbQwrrOY/w-d-xo.html

[@manojnair7007]

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

[@TechCoach]

You just have to add a partition by clause while creating the MV view :)

[@sum582]

very well explained

[@TechCoach]

Thanks Suman for the kind words :)

[@chandrasekhar9819]

THANK YOU

[@TechCoach]

Hi Chandra , I am glad I could help :)

[@harleenoberoi122]

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

[@TechCoach]

Thanks Harleen, Sure I will work on it.

[@RamGuptaoracle]

Really appreciate the effort. Keep continue your good work

[@TechCoach]

Thanks a lot Ram for the kind words.
This video may interest you as well.
th-cam.com/video/hW7knBX3KA0/w-d-xo.html

[@bangaloredairies9243]

YOU ARE THE BEST

[@TechCoach]

Thanks a lot buddy for the kind words :)

[@abhishekgharpure9444]

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

[@francisosei6582]

It improve my understanding on MV

[@TechCoach]

I am happy that I could help :)

[@psaikishore3210]

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

[@entwinedtechnologies3893]

just what i needed!!

[@TechCoach]

Thanks for the kind words

[@burelasekhar4044]

What are the monitoring views in oracle database

[@TechCoach]

I am sorry buddy I haven't come across them yet. Let me read about them a little

[@burelasekhar4044]

Ok

[@Roamingcurlcircuit]

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 :)

[@TechCoach]

Meenu Yadav Haha. Thanks a lot for the kind words.
I have a small request, I am working on this new channel "An Indian Abroad".
It would really help me if you watch and subscribe to it.
th-cam.com/video/HBQHekM1U2c/w-d-xo.html

[@Roamingcurlcircuit]

Tech Coach sure I'll do.

[@michellegracerobinson3297]

Great tutorial!

[@TechCoach]

Thanks a lot Michelle for the kind words :)

[@dkg5157]

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

[@TechCoach]

+D K G Sure I will be making videos on Indexing real soon and then I will try to make some on collections as well

[@satvinderbhangu361]

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

[@AhmedKamal-ps9rq]

great video from a great man

[@TechCoach]

Thanks a lot AK for the kind words :)

[@AhmedKamal-ps9rq]

@@TechCoach can u plz give us tutorial for db link from oracle 12c to sql server 2014 because i am stuck in this..using gateway or odbc..plz sir..regards from egypt to india

[@thehappybee4564]

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

[@TechCoach]

Thanks Piya for the kind words,
The next video in this series may help you as well.
th-cam.com/video/JsJqJ7Pzne4/w-d-xo.html

[@dn9416]

Excellent

[@shourabhpayal1198]

Good work sir. I have subscribed :)

[@TechCoach]

Thanks for the kind words buddy :)

[@pethilrajramachandran8095]

WHAT IS MEANT BY VIRTUAL TABLE AND PHYSICAL TABLE

[@TWGTravelwithGandharv]

Great video!! Thank you so much.

[@TechCoach]

Thanks a lot for the kind words buddy

[@TWGTravelwithGandharv]

@@TechCoach Bro, I need some help with my university assignment. I am creating a data mart for the first time. I need some advice with my workings. Is it possible to speak to you in some way. I will really appreciate your help! If you have time, I'll be in ur debt. Its kind a urgent!!!

[@krishnad9847]

Its Great :)

[@TechCoach]

Thanks a lot for the kind words,
I am working on this initiative, a new youtube channel named "an Indian Abroad" I would really appreciate if you watch, subscribe and share the video with your friends.
th-cam.com/video/HBQHekM1U2c/w-d-xo.html

[@musietsehay814]

thank's friend

[@TechCoach]

Thanks Musie Kebede for the kind words.
I have a small request, I am working on this new channel please do watch and subscribe to it.
Your support is my motivation. th-cam.com/video/JobONiVWA9Q/w-d-xo.html

[@ayushmittal8857]

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

[@burelasekhar4044]

Pls give a reply to me