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
What are the sql aggregate functions?
What is error ora-12154: tns:could not resolve the connect identifier specified?
What's the difference between inner join and left join?
Can we use joins in subquery?
Differentiate pl/sql and sql?
What do you understand by pl/sql packages?
How do I quit sql?
What is an intersect?
What is difference between hql and native sql?
Does sql profiler affect performance?
Is sqlexception checked or unchecked?
How do I start sql profiler?
How to select 10 records from a table?
what is user defined functions? : Sql dba
Can a trigger call a stored procedure?