Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NickStan
Starting Member
36 Posts |
 Posted - 2012-05-17 : 10:30:33
|
| Hi allI have an Oracle query that gets sales data for the past 10 days.This query is well optimized and takes 2 min 13 seconds to run in Oracle and returns 344427 records.If I run the same query via a Linked Server on my SQL 2008 R2 machine it takes 13 min 55 sec to complete.The provider that the linked server is using is: oraOLEDB.OracleAre there any provider options that I can look at changing or anything else at all that could speed up the query time?Thanks |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-05-22 : 15:05:41
|
| Would the option of have the data from Oracle dumped to SQL Server work for you?<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
NickStan
Starting Member
36 Posts |
Posted - 2012-05-23 : 04:32:38
|
| When you say having the data dumped from Oracle, do you mean have text dump files produced that can be used for the import?Unfortunately this is not an option for us because all of our Oracle data sources are managed and serviced from our US branch. |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-05-23 : 11:44:36
|
| Unfortunately this is not an option for us because all of our Oracle data sources are managed and serviced from our US branchNot sure why that would make a difference? Another option is to slap a rest service on top of the data out there and have your ssis consume the rest service<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
Slow open query to get Oracle data