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

Question

note in the lesson on views

Answer 1

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.