Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    13

    Unanswered: materilized view question

    is it possible to build materilized view which consist group by query
    of some table but when it refreshing it will keep the old data which store
    in it and will update the new one ?

    for example i have a group by query which take statistics on some table every month.

    I need that the materilized view will store the statistics and will keep the old resault.

    thanks

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    No, a materialized view can only store the "current" results of its defining query. You will need to maintain this history yourself.

Posting Permissions

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