Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56500 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
What is incremental aggregation?
Define the various join types of joiner transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Quickly characterize reusable change?
Global and Local shortcuts. Advantages.
What is source qualifier transformation in informatica?
What is status code in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the types of schemas we have in data warehouse.
Difference between Target-based loading and constraint-based loading?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is difference between a gateway node and worker node?
Explain how to import oracle sequence into informatica?
