Re: Problem with database link from Oracle Ve
Date: 1995/04/27
Message-ID: <3npbhl$oig_at_webe.hooked.net>#1/1
Oracle indexes DO work across links but not with a join!
One way to move around this issue is to code the join with cursors in a PL/SQL block. You would create a cursor which selects records from the remote table. Your cursor would need an input parameter which you derive from a select statement of your other table.
By the way, if your join would address 2 remote tables on the same database, then once again Oracle would be able to use indexes. The ORACLE7 optimizer is smart enough to realize that both tables are tables in the same remote database, and consequently it turns the entire statement over to the remote database,which executes it and returns the result set.
Walter Schenk
SoluTech Consulting
Received on Thu Apr 27 1995 - 00:00:00 CEST