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 your daily office routine?
What is the difference between mdf and ndf files?
What is structural independence and why is it important?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
how would you get the current date in mysql? : Sql dba
What is the primary use of normalization?
Can you load data into multiple tables at once? : aql loader
What is pivot in sql?
Does view contain data?
what is dbms? : Sql dba
What is localdb mssqllocaldb?
How is indexing done in search engines?
How many disk partitions should I have?
which operator is used in query for pattern matching? : Sql dba
What plvcmt and plvrb does in pl/sql?
