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 cross join? : Sql dba
List the different type of joins?
What is t sql in sql server?
Which nosql database is best?
How to run pl sql program in mysql?
How do I find duplicates in a single column in sql?
What is the process of debugging?
Enlist the data types that can be used in pl/sql?
What is materialized view. What are different methods of refresh?
How do I write a sql query in pgadmin 4?
What is %type in pl sql?
What is coalesce in sql?
What are different sql data types?
Explain select statements in sql?
What is pls integer?