We have a Oracle 8 database set up as a Linked Server in our installation of SQL Server 2000.
When running simple "SELECT * FROM WHERE" queries it's running very slow.
For example, the query "SELECT * FROM Commitment WHERE Week = 200430" takes between 17 and 23 seconds to run on SQL Server. The same query using a linked table via Access 97 takes milliseconds to run.
Has anyone any ideas as to what is slowing the performance?
[SQL Server 2000