Saturday, 12 September 2009

Performance Tuning - Question 065.

In a materialized view, which of these refresh modes may be chosen as a performance-improving alternative?

A . AUTOMATIC

B . COMPLETE

C. FAST

D . MANUAL

E . DIFFERENTIAL

Explanation:

Answer C: The FAST refresh mode only sends individual changes to the target materialized view; this is usually significantly faster than a COMPLETE refresh, which resends all rows in the master table. Manual and automatic describe modes used to schedule the refresh jobs. DIFFERENTIAL is something I just made up.

No comments:

Post a Comment