Found another little tidbit that might be of use. The SQL Server
system administrator can configure the OLE DB provider to set a couple
1. In Enterprise Manager, right-click on the server definition that
uses the OLE DB provider you want to set the properties.
2. On the General tab, click Options...then set the properties
The settings that we found that might help our performance are:
1. NestedQueries - If nonzero, indicates that the provider allows
nested SELECT statements in the FROM clause. Setting this option would
allow SQL Server to delegate certain queries to the provider that
nesting SELECT statements in the FROM clause
2. IndexAsAccessPath - If nonzero, SQL Server attempts to use indexes
of the provider to fetch data (by default, indexes are only used for
metadata and are never opened)
> Have you tried looking at the webpage
> er.asp?LN=EN-US&SD=gn&FR=0 for different ways to set up your
> We are using the Oracle 7.3 and SQL 7 on an NT4.0 system. I will do
> testing over this weekend to see if there is any performance issues.
> keep each other advised of the progress if you don't mind.
> Does anyone else have some insight?
> > We've created a link to an Oracle 7.3 server using
> > but are having performance issues with the connection. We
> > some loss of speed with the link, but queries that would run almost
> > instantaneously on local SQL Server tables are taking up to 15
> > to execute across the link. Creating indexes on the Oracle tables
> > hasn't seemed to help.
> > Could anyone provide some suggestions for improving the response
> > when accessing data over the link? Are there any additional
> > configuration options that might help our cause?
> > Thanks in advance,
> > --
> > Aaron Rolloff
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Sent via Deja.com http://www.deja.com/
Before you buy.