Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009

    Unanswered: Materialized View Refresh behaviour


    Question is regarding how a materialized view is fast refreshed.

    Master table A ------- has MV A as the materialized view.

    Now, A is a warehouse table which gets truncated and reloaded at regular intervals even if the data does not change. So even if the table is truncated, it is reloaded with exactly the same records or a very small net change.

    Will MV A get completely refreshed after every warehouse ETL or MV A will get refreshed by the small net change.

    Some insight into how the behaviour of materialized view refresh is would be useful.



  2. #2
    Join Date
    Jul 2003
    did you read the documentation for your oracle version?
    answer = it depends - not enough information.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts