Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13229 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sindhu
View - store the SQL statement in the database and let you
use it as a table. Every time you access the view, the SQL
statement executes.
Materialized view - stores the results of the SQL in table
form in the database. SQL statement only executes once and
after that every time you run the query, the stored result
set is used. Pros include quick query results
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / anju
materialized view can be used to precalculate the expensive
joins and aggregates prior to execution and the result is
stored in a table in database and can refer to it in
future. the adv of this is increse in performance.
view is nothing but an sql query stored. it will not store
data in tables
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / atiric sofrware(raja)
Views contains query whenever execute views it has read from
base table
Where as Materialised views loading or replicated takes
place only once which gives you better query performance
Refresh materialised views
1.on commit
2. on demand
(Complete, never, fast, force)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / praveen kumar pendekanti
In view if we do any operation that may be changes in table
and viveversa.View dont have memery allocation.if we create
a view as 'v1' on emp table and then we delete the emp
table there by 'v1' name will be exist in view list, but
data will not be there, if we create the emp table once
again it will automatically link to that 'v1'view.
But in the case of M.views the changes that made in table
cannot be seen in M.view.M.views have separate memery
allocation if we delete the table the M.view will be there.
M.view is read only view,D.D.L oerations are not possible
on this M.view. M.view are used in dataware housing.
| Is This Answer Correct ? | 1 Yes | 0 No |
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
Write the prerequisite tasks to achieve the session partition?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is difference between a connected look up and unconnected look up?
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
What is the difference between IN and Exists in Oracle?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Target increases every day even though no new record was inserted
What are the data movement modes in informatcia?
What is Performance tuning in Informatica?
Teradata 
