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...

Difference between views and materialized views?

Answer Posted / rahul khanke

views : this are the vertiual table.. views dosent stores
the data.. if we update the table then updation is in
actual table..
M view : this are the tables based on one or more tables..
this stores the data.. updation is done then actual
updation is in M. view itself..

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is left join in postgresql?

1051


What does rownum mean in sql?

1030


Which command is used to call a stored procedure?

1002


Why do we use procedures?

963


what is column? : Sql dba

1006


Is there any restriction on the use of union in embedded sql?

1160


Does view store data in sql?

969


What is sqlca in db2?

974


Explain unique key in sql.

1017


Does sql profiler affect performance?

998


Why trigger is used in sql?

976


What is example of database?

1061


What does cursor do in sql?

1029


What is pivot in sql?

918


Is sql between inclusive?

1137