Hi all,
I am having major performance issues between my linked server (SQL Server) and an Oracle10 db. I have created a number of views in my SQL Server database which map to corresponding Oracle tables via a linked server.
In my Oracle environment via Sql*Plus I run a simple query (count) which does a join between a 400K table and a 2.5 mil table - this takes about 10 seconds.
In my SQL Server environment using the...
aberton
Last Activity: Feb 25 '08, 01:59 AM
Joined: Feb 16 '08
Location:
-
Microsot Linked Server & Oracle10 Performance Issues
-
Linked Server and Oracle10 Performance Issues
Hi all,
I am having major performance issues between my linked server and an Oracle10 db. I have created a number of views in my SQL Server database which map to corresponding Oracle tables via a linked server.
In my Oracle environment via Sql*Plus I run a simple query (count) which does a join between a 400K table and a 2.5 mil table - this takes about 10 seconds.
In my SQL Server environment using the views created...
No activity results to display