August 12, 2009 at 5:27 am
What are the tips to tune sql query in data ware housing env. Apart from adding right indexes?
"More Green More Oxygen !! Plant a tree today"
August 12, 2009 at 7:34 am
Is there a cube on top of it or are you talking about a relational DW?
CEWII
August 12, 2009 at 10:05 pm
I have the same scenario here ....
ETL package to load of data insert are taking in table "history_info" and
then these data are compared with other tables so again a fetching all records to compare. there were 2 packages one load and another fetch.
My query is slow while fetching the records as there lots of records :w00t:. Any tips to tune.
Cheers,
Got an idea..share it !!
DBA_Vishal
August 12, 2009 at 10:10 pm
No cube is defined.
"More Green More Oxygen !! Plant a tree today"
August 12, 2009 at 10:44 pm
Build some pre-aggregated data tables. Add up common combinations, by month by customer and such. Indexes on almost any field that will be filtered on.
I guess I need a little more information about your design and the problems you are having.
CEWII
August 12, 2009 at 10:48 pm
vkundar:
It sounds like you have a stage process and then a load process from staging. Is there a cleaner method than comparing all the fields on the rows?
The stage process will run very fast even with a lot of records IF the destination table it is populating into is empty, it can then do FAST BULK LOADs..
Just like the poster I would need to know more about your design and your problems.
CEWII
August 13, 2009 at 2:54 am
Hi vkundar, can you show us the query you are using to fetch the data? (The one that's taking long)
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply