Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14449 Views
- I also Faced
- E-Mail Answers
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
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
Different circumstance which drives informatica server to expel records?
How to generate sequence numbers without using the sequence generator transformation?
Explain scd type 3 through mapping.
What is DR strategy for Informatica project?
Explain the use of aggregator cache file?
lookup transformation with screenshots
Explain about cumulative Sum or moving sum?
How can we create index after completion of load process?
What are the different types of transformation available in informatica.
permutations of mapplet
How do you update the records with or without using update strategy?
What are the tasks that can be performed using sq?
What is persistent lookup cache?
waht type of interface is used for testing the data in informatica
