Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / muhammadrashidmughal
In a database management system following the relational
model, a view is a virtual table representing the result of
a database query. Whenever an ordinary view's table is
queried or updated, the DBMS converts these into queries or
updates against the underlying base tables. A materialized
view takes a different approach in which the query result
is cached as a concrete table that may be updated from the
original base tables from time to time. This enables much
more efficient access, at the cost of some data being
potentially out-of-date. It is most useful in data
warehousing scenarios, where frequent queries of the actual
base tables can be extremely expensive.
In addition, because the view is manifested as a real
table, anything that can be done to a real table can be
done to it, most importantly building indexes on any
column, enabling drastic speedups in query time. In a
normal view, it's typically only possible to exploit
indexes on columns that come directly from (or have a
mapping to) indexed columns in the base tables; often this
functionality is not offered at all.
Materialized views were implemented first by the Oracle
database.
There are three types of materialized views:
1) Read only
Cannot be updated and complex materialized views are
supported
2) Updateable
Can be updated even when disconnected from the master site.
Are refreshed on demand.
Consumes fewer resources.
Requires Advanced Replication option to be installed.
3) Writeable
Created with the for update clause.
Changes are lost when view is refreshed.
Requires Advanced Replication option to be installed
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are the differences between sql server and mysql.
What is a derived table?
What is the sql server agent?
What is Service Broker in sql server 2012?
How do you rebuild an identity column?
What is implicit mode in sql server?
How you can move data or databases between servers and databases in sql server?
How do I get to sql server configuration manager?
How to view existing indexes on an given table using sp_help?
Explain Normalization and DE normalization
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to configure odbc dsn with different port numbers?
How extra digits are handled with numeric data type literals?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
