Why View don't need space to store in a database? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Why View don't need space to store in a database?

9th Apr 2016, 1:09 PM
Qiao Zhang
Qiao Zhang - avatar
3 Answers
+ 4
A view is created based on sql queries, meaning that each time you want to open a view, the data is fetched using the queries. So, basically, the data is in the underlying tables, which are used to generate the view.
23rd May 2016, 4:37 PM
James Flanders
+ 1
data of view is stored in ram, you can say that a select statement is view in itself
14th Jul 2016, 7:47 PM
manish rawat
manish rawat - avatar
0
views a stored on one of the system databases, not the database we're working with.
2nd Jan 2017, 6:24 AM
Lukus Graham
Lukus Graham - avatar