Poor performance of linked oracle server
Posted on 2004-09-29
Am wondering if anyone may able to offer any suggestions for a problem I'm having with a SQL linked servers.
I've got a SQL server running which has a linked server to an oracle database. I'm finding that a query run via the SQL server takes signifigantly longer than if I run the same query with a straight ODBC connection. (4 seconds on ODBC vs 4 minutes 50 seconds with a linked server.)
Any ideas about what could be causing the lag?