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

What is the differnce between view and materialized view

Answer Posted / papia

view does not contain actual data but MV contains data.MV
needs to be refereshed after a particular interval.Bit when
a view is queried it actually queries the underlying tables.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use 'mysql' to run sql statements? : Sql dba

986


What is pl sql package?

993


What is keys and its types?

1022


what is sql server agent? : Sql dba

1030


How do you pronounce sql?

957


how do you tune the slow running queries in oracle db , explain the methodology

2072


Do stored procedures prevent sql injection?

920


What is lexical units in pl sql?

1054


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1044


What is a pdo connection?

948


What are the commands used in sql?

1017


In a distributed database system, can we execute two queries simultaneously?

998


How do you explain an index?

1224


What is pl/sql table? Why it is used?

991


How do I run a sql query?

969