are views stored in memory?
Views are a special version of tables in SQL. ... The view is a query stored in the data dictionary, on which the user can query just like they do on tables. It does not use the physical memory, only the query is stored in the data dictionary.