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.
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.
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
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.
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...........
Excellent explanation Ankit. Thanks a lot for providing such amazing knowledgeable videos.
My pleasure
Great explanation as always. I have a doubt on how is views different from stored procedure?
Thanks Ankit for the video. Waiting for the Redshift tutorial.
Man this is JUST MIRACLE❤
Hello Sir great explanation please also make a videso on stored procedures and index as well
Thanks for the great explanation!
Good explanation.. keep posting such many interesting videos 👍
Sure 👍
Thank You Very Much Sir
Insightful
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 😊
Superb explanation
Thank you 🙂
Thank you so much 🙏 ankit😊 You explained very clearly
My pleasure 😊
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!
Thankyou sir!
Nice video bro it's good..❤
great explanation
Glad you think so!
I got full clarity b/w Normal views and Materialized views just in one 13 min video
Cheers 🥂
very good brother!
how updateable views are diffrent ?
This is one of the common interview question.
Can somebody upload the "Returns" table inset query!
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.
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.
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
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
view and cte difference?
what is the diff between a View and a CTE?
Hi Ankit, Are you doing videos for Snowflake
What about materialised views in Sql server
It's unsupported in SQL server. In SSMS there are index views only.
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
Thank you sir❤