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 Materialized View? In What Scenario we Use
Materialized View?

Answer Posted / chandan kumar

The above answer is right till here....view is a virtual
table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also
same
like the view but it exist in rdbms.

We use the Materialized View in that Senerio when we have
large amount of database and we need to refresh that in a
time being.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does bitemporal mean?

1049


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

991


Do prepared statements prevent sql injection?

934


What is oracle sql called?

903


What is database migration?

949


What is mutating table error?

1158


what is not null constraint? : Sql dba

1007


what is sql in mysql? : Sql dba

1176


Can we use ddl statements in stored procedure?

1130


How to add a column ‘salary’ to a table employee_details?

994


Which command is used to delete a package?

1149


What is the purpose of the partition table?

1034


Mention what pl/sql package consists of?

980


How does a covering index work?

943


How do I create a sql database?

979