Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between views and materialized views?
- 5 Answers
- 22298 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guru
View: View is a virtual table, a query attached to it.
Actually it have not Stored query results. It will execute
and returns rows.
A materialized view is a database object that contains the
results of a query. They are local copies of data located
remotely, or are used to create summary tables based on
aggregations of a table's data. Materialized views, which
store data based on remote tables are also, know as
snapshots.A materialized view can query tables, views, and
other materialized views. Collectively these are called
master tables (a replication term) or detail tables (a data
warehouse term)
| Is This Answer Correct ? | 29 Yes | 0 No |
Answer / 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 |
Answer / a.jyothsna
VIEWS: Takes the output of a query
M.VIEWS: Stores the output of a query,Views can't store
the results of a query
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / pinkey
A view is just a stored query and has no physical part.
Once a view is instantiated, performance can be quite good,
until it is aged out of the cache. A materialized view has
a physical table associated with it; it doesn't have to
resolve the query each time it is queried. Depending on how
large a result set and how complex the query, a
materialized view should perform better.
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / naresh
View: - it is logical table,it doesn't contain any data,it's contain only select statement.
if you modify the data in view,it's immediately effect to the Base table.
it gets rowids same as the base table.
Materialized view: - M.V are mostly use in Data Marts.
| Is This Answer Correct ? | 0 Yes | 0 No |
Are views faster than queries?
what are the join types in tsql? : Transact sql
What is trigger in sql and its types?
Can we join two tables without common column?
Can two tables have same primary key?
Why are aggregate functions called so?
Why we use triggers in mysql?
Why truncate is faster than delete?
Explain the structure of pl/sql in brief.
What is embedded sql what are its advantages?
How many types of relationship are there?
Where is sql database stored?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
