Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56103 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harshakore
A view has a logical existence but a materialized view has
a physical existence.Moreover a materialized view can be
indexed,analysed and so on....that is all the things that
we can do with a table can also be done with a materialized
view.
| Is This Answer Correct ? | 110 Yes | 5 No |
Answer / senthil
hi,
we already know basic restrictions of view and materialized
view,
view is a logical or virtual table it doesn't have data on
its own, but materialized view has a physical structure it
stores data in local machine or on its own.materialized view
can be refreshed automatically or manually. but in view, if
any changes happened in the base tables, we want to reflect
the same in the view means view has to issue the select
statement again to the database
| Is This Answer Correct ? | 71 Yes | 6 No |
Answer / anju
A materialized view is a stored summary containing pre-
computed results.As the data is pre-computed, materialized
views allow for faster query answers
In warehousing applications, large amounts of data are
processed and similar queries are frequently repeated. If
these queries are pre-computed and the results stored in
the data warehouse as a materialized view, using
materialized views significantly improves performance
by providing fast lookups into the set of results.
A Materialized View generally behaves like a Index and it
can also have any Number of Aggregates and Joins.
| Is This Answer Correct ? | 37 Yes | 6 No |
Answer / papa
Materialized View caches the data,but view cannt store the
data all.
| Is This Answer Correct ? | 27 Yes | 11 No |
Answer / navas
View:It is a sql query which is executed and populates
results each time when the particular view is accessed.When
we make a DML statement in view it will affect the original
data available in datebase table.
Materialized view:Materialized view is similar to a table
that exists in the table space.The resultsets are fetched
and populated in materialized view from various table when
a meterialixed view is created and will be availabe until
the view is refreshed.
| Is This Answer Correct ? | 18 Yes | 5 No |
Answer / roshan
apart from all the above answer one more difference is:
suppose we delete a table then all the views becomes invalid but this is not the case with the materialized view. its most interesting feature is auto commit refresh...
| Is This Answer Correct ? | 13 Yes | 3 No |
Answer / surajit n bhowmick
A View is just a stored query and has no physical role.
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 does not have to resolve the query each time it is
queried. Depending on how large the result and how complex
the query, a materialized view should perform better.
| Is This Answer Correct ? | 12 Yes | 4 No |
Answer / manohara reddy
view is logic and virtual table. it does't hold data.it
allows DML Operations.when ever u update or insert in base
table or view automatically changed those.
materialized view is static. u want create m.view DBA
Privileges and permissions must. it hold data all. when ever
u update or create rows in base table , it update only
update base table. doesn't change.
| Is This Answer Correct ? | 5 Yes | 7 No |
Answer / tiklu
Materialized Views are used by men with Tiny Penis
Where are Views are for Women with loose Vagina
| Is This Answer Correct ? | 1 Yes | 14 No |
Answer / the tiklu
Materialized View is for Consumerist es, while Views
are for great men and sexy women.
| Is This Answer Correct ? | 7 Yes | 46 No |
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
Diffrence between static and dynamic cache
How to eliminate 1st and last rows from the source and load the inbetween rows.
How many ways are there to create ports?
in a table it has 200 rows the query is select 150 from tablename.whats the output
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
What is Cognos script editor?
wht target override?wht advantages it has compare to target update?
Teradata 
