Re: indexes and database links

From: John H. Yates <yates_at_sas.upenn.edu>
Date: 1998/03/21
Message-ID: <6f1ho4$7vt$1@netnews.upenn.edu>#1/1

FlyingVee (b-horton_at_worldnet.att.net) wrote:
> John H. Yates wrote:
> >
> > Could the lack of response to this query mean that others don't have this
> > problem?
> >
> > John H. Yates (yates_at_hiker.sas.upenn.edu) wrote:
> > > Our Oracle server queries databases on another machine via a database link.
> > > We have found that indexes on the remote server are not used for these
> > > queries. How can we make our queries use the remote database indexes?

> > > Thanks, John
> > > yates_at_sas.upenn.edu
> How do you know they aren't?.

My staff has been told that by those who run Oracle on the machine we connect to. When they run our query, it takes less than a minute. When we run the query from our machine over the net, it takes more than five minutes. (for more details I'll have to ask my staff on Monday)

John Received on Sat Mar 21 1998 - 00:00:00 CST