Answer Posted / narenkumar reddy
Mv is database object it contain the data stored physically
from select stmt of query
first time it will get the data base table next time onwards
based on refresh methods mv are created tables and views and
also mv
there three types of refresh methods
1.complete(the whole query execute)
2.fast(only modified records are updated target table i.e
incremental loading)
3.force(some times means when we r using agg function on
that time fast option is not working so we go for force option)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between instead of trigger and after trigger?
What are triggers in sql?
Difference between truncate, delete and drop commands?
What happens when a trigger is associated to a view?
Does truncate free space?
What is materialized view in sql?
Is oracel sql developer written in java?
what is isam? : Sql dba
How do I run a sql query?
What is user in sql?
What is the difference between explicit and implicit cursors in oracle?
What is optimistic concurrency control? : Transact sql
Which language is used in sql?
how can we repair a mysql table? : Sql dba
How does postgresql compare to oracle/db2/ms sql server/informix?
