Re: HELP needed w/SQL*NET V1

In article: <3i2d41$rk8_at_canton.charm.net> maif_at_charm.net (MD Automobile Insurance Fund) writes:
>
> We are currently running Oracle version 6 with SQL*NET v1. I have set up
> a database link to a remote database. I am trying to run a query doing a
> join of 2 tables, both on the remote machine. Both tables are indexed by
> the columns being joined. I am not getting any response. I can see that
> the link is made and the query is running by logging into the remote
> machine and bringing up the SQL*DBA monitor. If I query against 1 table
> at a time the response is instantaneous. It seems as though the indexes
> are not being used on a join condition. I have also tried using a
> subquery and get no response.
>
> If anyone can offer any help or has any suggestions it will be greatly
> appreciated. Thanks.
>
> --
>
> --
> maif_at_charm.net MD Automobile Insurance Fund
>
>

-- 

	With version 6 Oracle when you have a distributed query like this
all the rows are transmitted back the the originating site for the resolution
of the query, as the index doesn't exist on your database then it cannot be 
used in the join which will be performed on your local machine.

	Hope this helps.

---

	Tim L