Re: indexes and database links

A DBA from the remote site says:
"When you are accessing a table accross a database link, you do not have access to the remote database's data dictionary. Effectively you cannot use any of the indexes on the remote machine." Is there a privilege required that they haven't given us to be able to use the indexes? I find it difficult to believe this would be the default for searching Oracle databases. If you have access to the database table itself, you should have access to its indexes, no?

John

Ken Friday (ken_friday_at_pleasantco.com) wrote:
> John,
 

> Are your queries written to provide the information necessary to utilize
> the indexes ? For example a literal comparison. The local database will
> send has much qualifying information as it can but basically it parses your
> query and sends a query of it's own to the remote database. If you're
> joining between local and remote tables it will most likely request a full
> set from the remote database.
 

> Ken F.
 

> John H. Yates <yates_at_hiker.sas.upenn.edu> wrote in article
> <6es01r$n3u$1_at_netnews.upenn.edu>...
> > 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
> >
Received on Wed Mar 25 1998 - 00:00:00 CST