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
What are sql data types?
What are the advantages of stored procedure?
What is oracle pl sql developer?
List different type of expressions with the example.
What is a boolean in sql?
Explain locks? : Transact sql
What is a heap in sql?
what are integrity rules?
What is use of term?
Why is there a need for sqlcode and sqlerrm variables?
What are the two characteristics of a primary key?
How long it takes to learn pl sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is coalesce sql?
How do I view a sql trace file?
