6 Replies Latest reply: Oct 31, 2013 3:32 AM by Rikab Kothari RSS

    Optimal way to load last 8 week data



      I try to load only the last 8 week data, so I use below scripts:

      where WEEK >= to_number(to_char(sysdate-56, 'iyyyiw')) and WEEK <= to_number(to_char(sysdate-7, 'iyyyiw'));

      Then I store this data to a qvd.

      However as the database is too big, I don't want to load 8 week data each week. I think it will be faster to delete the earliest week in the qvd, then append the new week into the qvd each time I reload. Is it possible to do that?