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
Explain what is rdbms?
How do you run a query?
What is the meaning of disabling a trigger?
What is materialized view. What are different methods of refresh?
explain mysql aggregate functions. : Sql dba
What does select count (*) mean in sql?
What is scalar and vector?
How many developers work on postgresql?
How will you distinguish a global variable with a local variable in pl/sql?
Which normal form is best?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How many types of triggers are there in pl sql?
what is the command used to fetch first 5 characters of the string? : Sql dba
What is the difference between function and procedure in pl/sql?
Can we use ddl statements in stored procedure sql server?
