January 17, 2014 at 12:15 pm
Hi,
My report query is having 10 unions. Execution time in SQL server is 20mins. no of records are 20,00,000.
So I have decided to do place the query logic in ETL. for this I have taken the query(10 unions) as source and the final result into a table. now im tryng to qury the final table then the query execution time is 1 min.
But the problem is ETL is taking 1 hr time to load the data.
Please suggest the techniques to reduce the execution ETL execution time.
Thanx In advance.
January 17, 2014 at 12:20 pm
raghavender.2369 (1/17/2014)
Hi,My report query is having 10 unions. Execution time in SQL server is 20mins. no of records are 20,00,000.
So I have decided to do place the query logic in ETL. for this I have taken the query(10 unions) as source and the final result into a table. now im tryng to qury the final table then the query execution time is 1 min.
But the problem is ETL is taking 1 hr time to load the data.
Please suggest the techniques to reduce the execution ETL execution time.
Thanx In advance.
There is no chance anybody has of providing any help with this level of detail. This is like taking your car to the mechanic and saying "My car doesn't work, how much will it cost to fix it?".
At the VERY minimum we need to an actual execution plan. Table definitions and indexes would be second.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 17, 2014 at 12:22 pm
Sounds like the code could use tuning. Unfortunately you have provided nothing with which to work with in this regard.
Please read the following article and follow the steps in it regarding what you need to post and how to do it.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply