| Report taking long time [message #180888] |
Wed, 05 July 2006 13:51  |
srinivas4u2
Messages: 66
Registered: June 2005
|
Member |
|
|
Hi,
DB Version - 9.2.0.7
O.S - Aix 5.2
Type - Datawarehouse
I have a report that runs every morning to collect sales statistics from first quarter till that day. I would like to know if there is any option by which I can just add the new statistics to the previous day's statistics instead of running (or calculating)the report from the beginning. The reason being as the data is becoming more each day the report is taking longer to complete.
I hope I have made the question clear.
P.S - Don't want to use materialized views.
Thanks,
Srinivas
|
|
|
|
|
|
| Re: Report taking long time [message #180908 is a reply to message #180891] |
Wed, 05 July 2006 15:41  |
srinivas4u2
Messages: 66
Registered: June 2005
|
Member |
|
|
Thanks for the response Mahesh but I am afraid you did not understand my question.
"You can ask your warehouse / reporting architect to maintain a seperate 'history' based on some timestamp" - Do you mean a separate table? I am sorry I didn't understand what you mean here.
I want the latest statistics in the report each day , since the report is being made for 1yr (let's say), I just want to add yesterday's statistics to day before yesterday's report (since it has the statistics for 1yr). Please let me know if you know of anything other than materialized views.
Thanks,
Srinivas
|
|
|
|
| Re: Report taking long time [message #180986 is a reply to message #180908] |
Thu, 06 July 2006 03:12 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
|
You could use a 'Poor mans materialized view' and simply store the data that you need in a table. That way each day you could add another row to the table without the overhead of generating all the previous data.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
