I have one very big table. I collect data every 5 minutes. The table
has data about 2 years.
I have to build a summary table (e.g., calculating MAX, MIX) for a
day to store my summary data so I create a temporary table to keep data
for specific day from big table. I am using PL/SQL.
My question is when I want to calculate summary data for the next day
and I have to REUSE the temporary table to keep data (retrieved from the
big table) for that day, should I drop the table and recreate it, or
should I only delete data in the table so I don't need to recreate it.
Which method is better? Why? Any other method?
Any suggestion would appreciate.
Thanks in advance,
-sirirut-