Interested to Buy Any Domain ? << Click Here >> for more details...
What is a materialised view?
- 5 Answers
- 8591 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / velmurugan uk
Materialised view is a snopshot/Copy of data(where data can
come out of select query) which can be refresed over a
period of time.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rashid ansari
materialized view is database object.it just like nomal
view but u can maniputale into mateialized view.when u
fatch data from remotly,materialized view provide fater
fatching data from remote database.when user manipulate on
actual table then simply refersh to materlized view
automatically update materlized view.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / deva
Its the data of the remote database. When we queried for
the data at the remote database/schema, the data/resuls set
is known as the materialized view.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / riddhi
1) view don't store data whereas mview contains copy of data
2) performance of mview is better then view
3)view contains updated data whereas mview not contain up to date Data because there is an activity of data refresh in mview
| Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
How to create tables for odbc connection testing?
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
Where is the export dump file located?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is an oracle and why it is used?
How to do clean up if create database failed?
How to experiment a data lock in oracle?
what are the advantages of running a database in NO archive log mode?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to check your oracle database 10g xe installation?
What is oracle rownum?
Oracle General 
