Click to See Complete Forum and Search --> : Linked Server from SQL 2000 to Oracle


yardleybates
08-28-2003, 12:13 PM
I have a SQL statement I am running against an Oracle database. If I run it in Oracle's query tool, it comes back instantly. If I run it in SQL's query tool, using a linked server it takes nearly 3 minutes to run. Has anyone come across something like this? Any ideas or suggestions?