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.
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)
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.
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
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 .
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...
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 ?😃
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
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
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.
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.
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.
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...
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
@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. ruclips.net/video/Ylm2f7tSAu0/видео.html ruclips.net/video/fvjCmlbpcYw/видео.html ruclips.net/video/bPSRKq-zjSQ/видео.html ruclips.net/video/Or_jlWc-w8E/видео.html Regards, Siva
![[SFM] Risky Recital](http://i.ytimg.com/vi/RzNkY1_Nk3o/mqdefault.jpg)
Thank you for your "Crystal Clear Explanation" Siva. Appreciate it. Thanks again and keep up the good work.
My pleasure!
You are rock man...good explain in very simple language and example
My pleasure bro
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...
very helpful, explained in a very simple way, thanks for the amazing content.
Awesome Explaination Sir Thanks alot 👌
@vicky, thanks for your comments bro 🙏
Best explanation I found on internet. Thank You.
Welcome 💐💐🙏👍
Superb superb explanation sir thank you for such great information 🙏
Welcome bro
Very Informative and Clear Explanation... Thank you so much Siva.. Keep up the Good work !!!
Thank you very much bro
your videos are so much helping brother
Best explaination till date.
Thank you 💐
Best explanation I ever seen ❤
Thank you
Thanks for the video ,i have got clarity on these concepts very well
Welcome 🙏, its my pleasure 🙂
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 ❤
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)
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.
Siva Sireeee....... You explained it very well. Tahnks.
Welcome
Well explained.... All topics....really appreciated for such type of help....
@rahul, welcome bro 🙏
It's in external level , modification done on base table will not affect the views of the end user
Excellent sir,we need more updates
🙏 thanks, please stay tuned for more videos
Can we create index on view or Mview and can we perform DML on Mview ??
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.
where exactly M-View gets stored ? Does it store as table data/file ??? Also can we update materialized view ?
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
Excellent teaching of Concept sir,. Keep it on, best wishes
Welcome bro
Nice explanation. Thank you!
Welcome
Thank so much sir, cristal clear explanation.. ❤️
Thank you
Hi shiva, which sceneries view and Mview will use, please make the video
my doubts are all clear, thanks
You are welcome
Thank for clarification ... Bless you
Welcome bro
On performance basic is mv is used if there is frequent dml operation?
Awesome explanation sir and its very informative
Welcome 🙏👍
When will we go for a view and when will go for Materialized view
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 ?
Excellent Explanation...very very good work siva..keep it up
My pleasure, thank you
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
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 .
Clear Explanation. sir
Thank you
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
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 ?😃
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
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
Very well explained..Thanks
Welcome
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
Thanks for your explain...
Welcome 💐🙏
thank u bro clean explanation
Welcome bro
Hi please post separate video on materlized view.... Refresh methods.
Sure, please stay tuned
Quite informative
Thank you
Can u make video on below question
Please create video on types of refresh in materialized view and more advance features in mv
Sure please stay tuned
When we perform an DML Statements in view table will it be effect on base table or not??
Yes, please check this video ruclips.net/video/UO-dJqCqjo8/видео.html
Please upload this video with an example? Views are created on top of materialized views ? And How?
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.
Can we do DML om MV?
Great👍🤟
Thank you
what is the purpose of creating materialized view??
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 ruclips.net/video/UO-dJqCqjo8/видео.html
Materialize view can be created on different schemes/database..... can we do the same view also ?
Yes.. Using db links
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.
When to use view and materialized view ?
Very informative video. Most of the videos voice is low. Hope it will be taken care
Hopefully recent videos are better
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.
Ji enable query write ku , seperate video poduga ji,, it will helpful for us
Sure Sabari, can you please eloborate little bit more ji
How to add columns in view
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
Hi Sir,
Please make tutorial on MV... refresh types etc.,
Yes, please stay tuned
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
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
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.
nice presentation
Thank you
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 👍
what is the default refresh method in Mv?
Force Refresh
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
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.
very nice sir
Thank you
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?
Mainly index types & use
Sure Manoj.
Started posting index related questions, Please check and share your views
Superb
Thanks Manoj
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.
ruclips.net/video/Ylm2f7tSAu0/видео.html
ruclips.net/video/fvjCmlbpcYw/видео.html
ruclips.net/video/bPSRKq-zjSQ/видео.html
ruclips.net/video/Or_jlWc-w8E/видео.html
Regards, Siva
Thank u sir
Pls improve sound quality
why do we need materialized view ?
For fat access the data . data will stay in cache memory after execution of query
Explain performance tuning concept deep explain video upload
Sure,I Will do.
Thank u
Welcome
👍👍👍👍
Video ok but voice very low
👌
🙏💐
82k view 😂