How could a refresh of materialised view be done? Discuss the advantages and disadvantages of your chosen method of refresh over the other techniques.

Write up to 250 words to answer How would you use a materialized view that can be used to enhance performance and undergo query re-write? Include the following in your answer:-
Use an external source of reference from your reading
Use an example to show how Query Rewrite can be confirmed
How updates on materialized views base tables can affect query rewrite
How could a refresh of materialized view be done? Discuss the advantages and disadvantages of your chosen method of refresh over the other techniques.
———-
Added on 19.04.2016 17:20
Write upto 250 words to answer How would you use a materialized view that can be used to enhance performance and undergo query re-write? Include the following in your answer:-
Use an external source of reference from your reading
Use an example to show how Query Rewrite can be confirmed
How updates on materialized views base tables can affect query rewrite
How could a refresh of materialised view be done? Discuss the advantages and disadvantages of your chosen method of refresh over the other techniques.

Last Completed Projects

topic title academic level Writer delivered