Nice explanation. Few points to add- 1. While creating Mviews, internal tables and index are created in same schema along with mview. 2. We can have partitions and indexes for mviews.
Thank you very much for sharing your knowledge...If am not wrong need below correction. For point no 2. in comparison of View and MV @9.55. For view, online data from underlying base tables and for MV it should be Offline/delayed data from MV instead of underlying base tables as last refresh data is returned...
Views generally used in database application where number of data are less like daily transaction and number of table that need to join to retrieve data are less then we use view.But we use materialized views where the query is complex and in the mat view many tables need to join and time consuming.In this scenario we use materialized view.In normal OLTP application we use views but for data warehouse application and business intelligence application where we generate reports based on some complex query and join we use materialized views.
Hi sir, I watch your all sql videos and it is very helpful for me. Thanks a lot for these videos. Can you please make a video on how we can refresh materialized view or a detailed video on materialized view.
Thank you very much for the great content! Could tell me where could I find the Video related to last part of the video? (about the question: in which scenarios should we use wich concept)
ora - 12015 cannot create a fast refresh materialized view from a complex query Cause: Neither ROWIDs and nor Primary key constraints are supported for complex queries..Plz make one video on this topic
Hi Sir , nice explanation. I have one query, currently I'm creating one Mview (base on 2-3 table) monthly on first date but while using that Mview, in next day some of the packages (base on Mview) going in invalid objects status . So kindly clarify why this packages going in invalid objects status and how to avoid it ? Thanks in advance
Good One...please make videos on performance tunning... if particular doesn't give the performance what we have to check...or what is basic methods of tunning the query
nice sir .. 1) what is dynamic sql?explain in details. 2) what is ref-cursor?expain in details. this above questions plz make a videos sir ...interview point of plz...
If materialised views have their separate physical storage then why shld v not create a subset of the main table, why a materialised view only ! If u may answer pls .
Hi Shiva, your way of teaching is quite interesting .have an question on this part whether we able to do any modification in created M-view without dropping.
Hello Sir , just a question Suppose we have a materialized view which we refresh periodically ! and then we just drop the base table of that M_VIEW ! What will happen when M_VIEW will e refreshed the next time ? I believe we will get some kind of error like source table do not exist
Appreciate your hard work! Well as per my experience : If you practice this playlist you are good to clear any service based firm for PLSQL role ! can't we use CREATE OR REPLACE MATERIALIZED VIEW mv_name ; syntax ?😃
Sure Manoj, Already posted on trigger concept & types., Next video i will cover DML trigger types and its concepts. send if you have any specific question on DML trigger, i will answer as part of that video.
Sir, Could you please answer this question- why we are going for a Materialized? I mean as view doesn't store any data so there will not be any space issue but Materialized view stores data in a physical memory location so it will take space then also use Materialized view why?
There are many application where space is not the primary concern but the query time is more important like data warehouse and BI application where we use materialized views.
Ideally we should not compare both, view is just a named query, that executes and returns value, whereas synonyms are alternative name for any database objects
Hi Siva, Could you please confirm how many Mviews are there.Could you please make a video on How to create types of Materialized view 1. READ ONLY 2. WRITABLE3. UPDATABLE Note: particularly How to create Updatable Mview and give us an example of how to update the base table through Updatable Mview. Thanks in Advance...
@Madhavi, Thanks for your comment, Subquery I have already covered as part of interview question series, Links given below for your easy reference. Joins I will cover in upcoming videos, please stay tuned. ua-cam.com/video/Ylm2f7tSAu0/v-deo.html ua-cam.com/video/fvjCmlbpcYw/v-deo.html ua-cam.com/video/bPSRKq-zjSQ/v-deo.html ua-cam.com/video/Or_jlWc-w8E/v-deo.html Regards, Siva
Nice explanation. Few points to add- 1. While creating Mviews, internal tables and index are created in same schema along with mview. 2. We can have partitions and indexes for mviews.
Thank you very much for sharing your knowledge...If am not wrong need below correction. For point no 2. in comparison of View and MV @9.55. For view, online data from underlying base tables and for MV it should be Offline/delayed data from MV instead of underlying base tables as last refresh data is returned...
Best explanation I found on internet. Thank You.
Welcome 💐💐🙏👍
very helpful, explained in a very simple way, thanks for the amazing content.
Thank you for your "Crystal Clear Explanation" Siva. Appreciate it. Thanks again and keep up the good work.
My pleasure!
Best explaination till date.
Thank you 💐
your videos are so much helping brother
Very Informative and Clear Explanation... Thank you so much Siva.. Keep up the Good work !!!
Thank you very much bro
Awesome Explaination Sir Thanks alot 👌
@vicky, thanks for your comments bro 🙏
You are rock man...good explain in very simple language and example
My pleasure bro
Can u give some scenarios- when views should be used and when materialized view should be used ?
Views generally used in database application where number of data are less like daily transaction and number of table that need to join to retrieve data are less then we use view.But we use materialized views where the query is complex and in the mat view many tables need to join and time consuming.In this scenario we use materialized view.In normal OLTP application we use views but for data warehouse application and business intelligence application where we generate reports based on some complex query and join we use materialized views.
@@kuntalbanerjee6903thnkyou ❤
Hi sir,
I watch your all sql videos and it is very helpful for me. Thanks a lot for these videos.
Can you please make a video on how we can refresh materialized view or a detailed video on materialized view.
Thanks for the video ,i have got clarity on these concepts very well
Welcome 🙏, its my pleasure 🙂
It's in external level , modification done on base table will not affect the views of the end user
Well explained.... All topics....really appreciated for such type of help....
@rahul, welcome bro 🙏
Siva Sireeee....... You explained it very well. Tahnks.
Welcome
Hello sir it was a very good explanation but please make a detailed video on materialized view as you have make on index and view.
Superb superb explanation sir thank you for such great information 🙏
Welcome bro
Excellent... Kindly Upload the the concept of performance and tunning
Thanks for your comment.
Working on performance tuning series of videos, will upload once done.
Thank you very much for the great content! Could tell me where could I find the Video related to last part of the video? (about the question: in which scenarios should we use wich concept)
Can we create index on view or Mview and can we perform DML on Mview ??
Excellent sir,we need more updates
🙏 thanks, please stay tuned for more videos
Hi shiva, which sceneries view and Mview will use, please make the video
On performance basic is mv is used if there is frequent dml operation?
Excellent teaching of Concept sir,. Keep it on, best wishes
Welcome bro
ora - 12015 cannot create a fast refresh materialized view from a complex query
Cause: Neither ROWIDs and nor Primary key constraints are supported for complex queries..Plz make one video on this topic
You can't create direct Mview for Fast refresh. 1st create logs then create Mview
When will we go for a view and when will go for Materialized view
where exactly M-View gets stored ? Does it store as table data/file ??? Also can we update materialized view ?
Nice explanation. Thank you!
Welcome
Excellent Explanation...very very good work siva..keep it up
My pleasure, thank you
Hi please post separate video on materlized view.... Refresh methods.
Sure, please stay tuned
Awesome explanation sir and its very informative
Welcome 🙏👍
Thank for clarification ... Bless you
Welcome bro
Thank so much sir, cristal clear explanation.. ❤️
Thank you
Hi Shiva , your videos are great and very informative ... just wanted to know if we can create view with unique column or like unique sequence id ?
Hi Sir , nice explanation.
I have one query, currently I'm creating one Mview (base on 2-3 table) monthly on first date but while using that Mview, in next day some of the packages (base on Mview) going in invalid objects status .
So kindly clarify why this packages going in invalid objects status and how to avoid it ?
Thanks in advance
Good One...please make videos on performance tunning... if particular doesn't give the performance what we have to check...or what is basic methods of tunning the query
sure, please stay tuned
Clear Explanation. sir
Thank you
my doubts are all clear, thanks
You are welcome
nice sir ..
1) what is dynamic sql?explain in details.
2) what is ref-cursor?expain in details.
this above questions plz make a videos sir ...interview point of plz...
@Rahul, Thanks for your comment,
Sure, I will post a video on dynamic SQL, and ref cursor soon, Pls stay tuned...
Thanks
If materialised views have their separate physical storage then why shld v not create a subset of the main table, why a materialised view only ! If u may answer pls .
Can u make video on below question
Hi Shiva, your way of teaching is quite interesting .have an question on this part whether we able to do any modification in created M-view without dropping.
Thank you bro, I guess no, however I will check and post back with detailed information
Please create video on types of refresh in materialized view and more advance features in mv
Sure please stay tuned
Hello Sir , just a question
Suppose we have a materialized view which we refresh periodically !
and then we just drop the base table of that M_VIEW !
What will happen when M_VIEW will e refreshed the next time ? I believe we will get some kind of error like source table do not exist
Yes we will get error
Very well explained..Thanks
Welcome
Appreciate your hard work!
Well as per my experience : If you practice this playlist you are good to clear any service based firm for PLSQL role !
can't we use CREATE OR REPLACE MATERIALIZED VIEW mv_name ; syntax ?😃
Thanks for your explain...
Welcome 💐🙏
Very informative video. Most of the videos voice is low. Hope it will be taken care
Hopefully recent videos are better
When to use view and materialized view ?
thank u bro clean explanation
Welcome bro
Please upload this video with an example? Views are created on top of materialized views ? And How?
Quite informative
Thank you
When we perform an DML Statements in view table will it be effect on base table or not??
Yes, please check this video ua-cam.com/video/UO-dJqCqjo8/v-deo.html
Can we do DML om MV?
Hello sir...
Can we perform dml statement in base table through view??
Yes, for simple view, its possible, for complex its not possible, please look into this video ua-cam.com/video/UO-dJqCqjo8/v-deo.html
what is the purpose of creating materialized view??
How to add columns in view
Sir pls share some more interview questions asked vedios like triggers concept & indexing part
Sure Manoj, Already posted on trigger concept & types., Next video i will cover DML trigger types and its concepts.
send if you have any specific question on DML trigger, i will answer as part of that video.
Ji enable query write ku , seperate video poduga ji,, it will helpful for us
Sure Sabari, can you please eloborate little bit more ji
Materialize view can be created on different schemes/database..... can we do the same view also ?
Yes.. Using db links
Sir, Could you please answer this question- why we are going for a Materialized? I mean as view doesn't store any data so there will not be any space issue but Materialized view stores data in a physical memory location so it will take space then also use Materialized view why?
There are many application where space is not the primary concern but the query time is more important like data warehouse and BI application where we use materialized views.
Plz provide some more topic on performance tunning
@rahul, sure will be posting, please stay tuned
Sir can u make difference between group by and partition by????
Sure bro, please stay tuned
Please make video on types of Materialised view in detail???
Sure Suraj, please stay tuned 👍
please make videos on types of materialised view and refresh methods in detail..
Sure please stay tuned 👍
create or replace materialized view vw_emp as select * from employees where department_id=50; not working in sql devoloper
Don't use Replace ,it will work.
Hi Sir,
Please make tutorial on MV... refresh types etc.,
Yes, please stay tuned
what is the default refresh method in Mv?
Force Refresh
Great👍🤟
Thank you
Can we fire DML statement on Materialized view ?
@ur, DML operation is not possible on read-only materialized views, however, you can do DML on updatable materialized view.
Pls improve sound quality
Hi sir
Can you please explain what is pass by value and pass by reference, thanks in advance
Sure bro, please stay tuned, will post soon
@@SivaAcademydo we get any message or how do we know that u have updated videos
@bhargava, click the bell icon next to subscribe button, to enable the notification, after that for any new video uploaded you will get a notification
What is the difference between view and synonyms?
Ideally we should not compare both, view is just a named query, that executes and returns value, whereas synonyms are alternative name for any database objects
you videos are good but volume is very low , we have to keep 100 then ony can hear you properly .
Thank you, I believe recent videos volume is good?
nice presentation
Thank you
Mainly index types & use
Sure Manoj.
Started posting index related questions, Please check and share your views
We can do same things using table then why need materialized views ?
Mviews provide additional advantages over table, like refresh etc.
@@SivaAcademy thank u so much
Hi Siva,
Could you please confirm how many Mviews are there.Could you please make a video on How to create types of Materialized view 1. READ ONLY 2. WRITABLE3. UPDATABLE
Note: particularly How to create Updatable Mview and give us an example of how to update the base table through Updatable Mview.
Thanks in Advance...
Sure, definitely, please stay tuned, will cover in upcoming videos
very nice sir
Thank you
why do we need materialized view ?
For fat access the data . data will stay in cache memory after execution of query
Good video bro,
👍👍
@@SivaAcademy hi siva, how to find no of weeks for a month in sql
Also,how to change snowflake schema to star schema.
Explain performance tuning concept deep explain video upload
Sure,I Will do.
👍👍👍👍
Thank u
Welcome
Superb
Thanks Manoj
Video ok but voice very low
👌
🙏💐
It's very nice teaching sir...can u please explain about joins and subquery
@Madhavi,
Thanks for your comment, Subquery I have already covered as part of interview question series, Links given below for your easy reference. Joins I will cover in upcoming videos, please stay tuned.
ua-cam.com/video/Ylm2f7tSAu0/v-deo.html
ua-cam.com/video/fvjCmlbpcYw/v-deo.html
ua-cam.com/video/bPSRKq-zjSQ/v-deo.html
ua-cam.com/video/Or_jlWc-w8E/v-deo.html
Regards, Siva
Thank u sir
82k view 😂