0

is view memory intensive as the note in the end mentions it recreates every time a query on view is made ?

note in the lesson on views

28th Aug 2016, 10:17 PM
rjamakai
rjamakai - avatar
1 Odpowiedź
0
No. A View is a SQL statement, rather than physical data. When queried, the data is stored in memory as a virtual table in the same way data from a SQL statement joining two tables together. A View is stored in the database to save you from having to regenerate the SQL statement every time. You would probably use the same memory if you manually created the SQL statement.
31st Aug 2016, 10:53 PM
Michael Skae
Michael Skae - avatar