OnDemand data warehouse table population for reporting purposes...performance?
Posted on 2011-09-20
My organization is running Oracle 10g. We have SSRS running with oracle tables.
The process is from a dashboard:
The user selects a report, that report in turn will populate globel temp tables
that are designed like a kimbel data warehouse.
So the procs are pulling data from legecy tables and populating dimension and fact tables.
Once this is completed, the next process is to return the data back to the report for the user.
Churning through large chunks of data I understand can cause performance issue. But even trying to load a small dimension table is taking
is taking too long.. example: 100 rows 10 secs
After trying to optimize the queries themselves, are there any other tips or tricks
I can use to speed up perfomance..
Changing the structures is out of the question as per organizational requirements..
( i guess until enough peope complain,, lol)
So I am looking for Query options and tricks to try an use...
Any and all help would be awesome.