What is the difference between view and materialised view?
Answer Posted / anurag arun edlabadkar
Difference Between Inline View & Materialized View?
You can use Materialized views to pre-aggregate the data
and improve the query performance. When you create a
materialized view, Oracle created a physical table to hold
data that would usually be read via a view. When you create
a materialized view, you specify the view's base query as
well as a schedule for the refreshes of its data. You can
then index the materialized view to enhance the performance
of queries against it. As a result, you can provide data to
your user in the format they need, indexed appropriately.
A View is a database object that is a logical
Representation of of a table. It is derived from a table
but has no storage of its own and often may be used in the
same manner as a table.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What do you understand by a term domain?
Briefly define a session task?
Why do we need informatica?
Do you find any difficulty while working with flat files as source and target?
What is the difference between informatica 7.0 and 8.0?
What are the different types of repositories created using informatica?
What is the difference between a connected look up and unconnected lookup?
Scheduling properties,whats the default (sequential)
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How do you promote a non-reusable transformation to reusable transformation?
Enlist the various types of transformations.
What do mean by local and global repository?
Target increases every day even though no new record was inserted
Why sorter is an active transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not