Re: indexes and database links

From: Ken Friday <ken_friday_at_pleasantco.com>
Date: 1998/03/23
Message-ID: <01bd5699$4f5bc040$8859a8c0@04653>#1/1

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 Mon Mar 23 1998 - 00:00:00 CST