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 many types of normalization are there?
What is column?
What is sql server and ase?
How many clustered indexes can you have?
Can we use insert statement in function?
How do I add a database to sql?
What does (+) mean in sql joins?
Can delete statement be rollbacked?
Can we connect to postgresql using sql developer?
Why should I use postgresql?
What is trigger and stored procedure in sql?
What is mutating error?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is sql procedures and functions?
when MSQL8.0 is in market
