Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Talk about views

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


Please Help Members By Posting Answers For Below Questions

What are the sql aggregate functions?

1106


What is error ora-12154: tns:could not resolve the connect identifier specified?

1055


What's the difference between inner join and left join?

984


Can we use joins in subquery?

1143


Differentiate pl/sql and sql?

1052


What do you understand by pl/sql packages?

1048


How do I quit sql?

935


What is an intersect?

1088


What is difference between hql and native sql?

1145


Does sql profiler affect performance?

976


Is sqlexception checked or unchecked?

950


How do I start sql profiler?

978


How to select 10 records from a table?

1142


what is user defined functions? : Sql dba

1018


Can a trigger call a stored procedure?

1052