Sir, can I get 10-15 min from your life I am confused for my career path I work as database developer from last 2y.next what to do I don't understand, Please can you guide
Great demo as always. Could you please make another video explaining the backend things of how altering a view (performing update to views) changes the contents of the base table as well TIA!
Bro, can you please make some videos on SQL stored procedure. I couldn't find tutorials anywhere. If you explain it, we can easily learn it. I am fond of your teaching.
Hi Ankit Vedio is good but I have some doubts in it. As a storage point it is clear. Data freshness also clear. Performance point i have some doubt it mean view and materialised will you the same plan hash value or it is different for view since it is taking data from base team , there might be a chance that base table search path might change,can you please help me with your input on this
1.Views are database objects while cte is not a database object rather it is temporary named result set generated on query for which it is defined. 2.Views are stored on disk while cte are stored on memory(Ram) which is a temporary storage. 3.Views can be referenced from anywhere within the database in which it is created while cte can be referenced only within the boundary of the statement for which it is defined. 4.Views can't be recursive while cte can be recursive.
From a query execution standpoint: 1. Views are virtual and/or actual tables u can update or alter whereas CTE are temporary result you can store while executing a query 2. Views can be called independently whereas, CTEs cannot be called independently (they are dependent on your full query execution) 3. CTEs results are gone once your SQL session is closed whereas views results remain as is
The concept is the same. However Snowflake’s materialized views are automatically refreshed whenever the base tables change, without requiring explicit commands from the user.
I have not understood from your example why materialised views are faster. The results are pre-computed in Views too,, both retrieve what is in the underlying table.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Please do like the video 😊
How can we schedule the refresh of the materialized view?
Sir, can I get 10-15 min from your life I am confused for my career path I work as database developer from last 2y.next what to do I don't understand, Please can you guide
Thank you so much Ankit sir for this wonderful video and clearing the concept of views in SQL..
I'm pretty much sure I'll not forget it now..
Really awesome explanation.. Thanks alot sir
You are most welcome
man dope data contents are coming , need more of this , waiting...........
Thanks Ankit for the video. Waiting for the Redshift tutorial.
Good explanation.. keep posting such many interesting videos 👍
Sure 👍
Excellent explanation Ankit. Thanks a lot for providing such amazing knowledgeable videos.
My pleasure
Man this is JUST MIRACLE❤
Insightful
Thanks for the great explanation!
Great explanation as always. I have a doubt on how is views different from stored procedure?
Hello Sir great explanation please also make a videso on stored procedures and index as well
Nice video bro it's good..❤
Superb explanation
Thank you 🙂
very good brother!
Hello please also make the playlist on case study using SQL It will help everyone and me too
It will be great if u explain this 😊
Thank you so much 🙏 ankit😊 You explained very clearly
My pleasure 😊
Thank You Very Much Sir
This is one of the common interview question.
great explanation
Glad you think so!
Thankyou sir!
I got full clarity b/w Normal views and Materialized views just in one 13 min video
Cheers 🥂
Great demo as always.
Could you please make another video explaining the backend things of how altering a view (performing update to views) changes the contents of the base table as well
TIA!
Bro, can you please make some videos on SQL stored procedure. I couldn't find tutorials anywhere. If you explain it, we can easily learn it. I am fond of your teaching.
For those, check out "Kudvenkat SQL Server Playlist", you'll find. I hope, Ankit Bansal created videos on Stored Procedure as well in future.
Hi Ankit
Vedio is good but I have some doubts in it.
As a storage point it is clear.
Data freshness also clear.
Performance point i have some doubt it mean view and materialised will you the same plan hash value or it is different for view since it is taking data from base team , there might be a chance that base table search path might change,can you please help me with your input on this
Adding to that point if mview has a dynamic refresh obviously it will degrade the db performance please correct me if I am wrong
how updateable views are diffrent ?
What would be the difference between Views and CTE then ?
1.Views are database objects while cte is not a database object rather it is temporary named result set generated on query for which it is defined.
2.Views are stored on disk while cte are stored on memory(Ram) which is a temporary storage.
3.Views can be referenced from anywhere within the database in which it is created while cte can be referenced only within the boundary of the statement for which it is defined.
4.Views can't be recursive while cte can be recursive.
From a query execution standpoint:
1. Views are virtual and/or actual tables u can update or alter whereas CTE are temporary result you can store while executing a query
2. Views can be called independently whereas, CTEs cannot be called independently (they are dependent on your full query execution)
3. CTEs results are gone once your SQL session is closed whereas views results remain as is
Wht is difference between snowflake materialized views and SQL materialized views bro can u explain please
The concept is the same. However Snowflake’s materialized views are automatically refreshed whenever the base tables change, without requiring explicit commands from the user.
view and cte difference?
Can somebody upload the "Returns" table inset query!
what is the diff between a View and a CTE?
Hi Ankit, Are you doing videos for Snowflake
I have not understood from your example why materialised views are faster. The results are pre-computed in Views too,, both retrieve what is in the underlying table.
In normal views they are not pre computed
What about materialised views in Sql server
It's unsupported in SQL server. In SSMS there are index views only.
Thank you sir❤