Difference Between SQL Views vs Materialized Views | Frequently Asked SQL Interview Question
Вставка
- Опубліковано 9 лют 2025
- In this video we will understand SQL views and difference Between SQL Views vs Materialized Views. This is a very frequently asked SQL interview question. This is the only video you need to answer this question in your next SQL interview.
script:
CREATE TABLE orders (
order_id INT,
order_date DATE,
product_name VARCHAR(20),
sales INT
);
INSERT INTO orders (order_id, order_date, product_name, sales) VALUES
(1, '2023-01-15', 'Laptop', 1200),
(2, '2023-01-17', 'Smartphone', 800),
(3, '2023-01-20', 'Tablet', 600),
(4, '2023-02-05', 'Smartwatch', 300),
(5, '2023-02-08', 'Headphones', 150),
(6, '2023-02-10', 'Monitor', 200),
(7, '2023-02-15', 'Keyboard', 80),
(8, '2023-02-20', 'Mouse', 50),
(9, '2023-03-01', 'Printer', 220),
(10, '2023-03-05', 'Camera', 500);
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregat...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN ba...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL P...
Data Analyst Spotify Case Study:
• Data Analyst Spotify C...
Top 10 SQL interview Questions:
• Top 10 SQL interview Q...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question...
Playlist to master SQL :
• Complex SQL Questions ...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_...
#sql #dataengineer
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...........
Man this is JUST MIRACLE❤
Excellent explanation Ankit. Thanks a lot for providing such amazing knowledgeable videos.
My pleasure
Thanks Ankit for the video. Waiting for the Redshift tutorial.
Good explanation.. keep posting such many interesting videos 👍
Sure 👍
Great as always , can you also make something similar on Partitions. Thank you bhaiya.
Yes, sure
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 😊
Thanks for the great explanation!
Insightful
Superb explanation
Thank you 🙂
Great explanation as always. I have a doubt on how is views different from stored procedure?
Thank You Very Much Sir
Hello Sir great explanation please also make a videso on stored procedures and index as well
Nice video bro it's good..❤
Thank you so much 🙏 ankit😊 You explained very clearly
My pleasure 😊
Explanation is So clear sir! But I have a doubt. Suppose, I have created a view on a complex query and I forgot to note down the query. Where Can I refer the query?
very good brother!
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 🥂
This is one of the common interview question.
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.
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!
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
view and cte difference?
how updateable views are diffrent ?
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.
So , it means Normal Views like Direct Query in Power BI and Materialized View Like Import Query ?
Yes it’s right analogy
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
what is the diff between a View and a CTE?
Can somebody upload the "Returns" table inset query!
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❤