Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do I sort a table in sql?
What is an exception in pl/sql?
What is indexing in sql and its types?
How do I remove sql developer from windows 10?
What are the differences between implicit and explicit cursors?
What are the three forms of normalization?
What does rownum mean in sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
what are ddl statements in mysql? : Sql dba
explain the difference between bool, tinyint and bit. : Sql dba
How long does it take to learn pl sql?
How do I know if I have sql express or standard?
how to create a table index in mysql? : Sql dba
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What are all the common sql functions?
