Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between views and materialized views?
- 5 Answers
- 22289 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why stored procedure is better than query?
What are inner and outer joins examples of both?
What is faster join or subquery?
How do I pipe the output of one isql to another?
How do I edit a stored procedure?
what is query cache in mysql? : Sql dba
how tsql statements can be written and submitted to the database engine? : Transact sql
How do you update a value in sql?
How does stored procedure reduce network traffic?
What are inbuilt functions in sql?
how to select unique records from a table? : Sql dba
Do ddl statements need commit?
Can we create view in stored procedure?
Why self join is used in sql?
Explain raise_application_error.
