Answer Posted / satish asnani
Simple and complex views do not occupy HD space. The data
remains with the base table and views are just stored
queries which fetch data from base tables. But Materialized
Views maintain a copy of the records in their own space.
That is Materialized views as name suggests store a local
copy of the records from base tables and definitely occupy
HD space.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What is flag in sql?
What are all different types of collation sensitivity?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
When you have to use a default "rollback to" savepoint of plvlog?
Is the primary key an index?
What is a variable in sql?
What is the difference between a primary key and a clustered index?
What are two statement types in sql?
What is the most common sql injection tool?
What is a dynamic query?
What are all the different normalization?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
how to return query output in html format? : Sql dba
What is a sql statement?
