What is a materialised view?
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 |
How to connect to a remote server?
Give the Types of modules in a form?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What is the use of file param in imp command?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is a database schema in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What are ddl statements in oracle?
What is a deadlock ? Explain .
What are a query and state the different types of queries and their uses?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
what are different types of locks?