Problem using remote index file

From: Franco NG <francong_at_netvigator.com>
Date: Mon, 4 May 1998 23:24:30 +0800
Message-ID: <6ikmgc$rea$1_at_imsp009a.netvigator.com>

I have a problem that cannot use the remote index file by using 'Join Table' SQL in current Database.
I tried to reconstruct the SQL, Oracle still cannot use remote index.

The environment & situation are following:

Current Database

---

EMP (EMP_ID - Primary Key)

Remote Database (Connected by DB Link)

---

WORLD_EMP (EMP_ID - Primary Key)

SQL Statement

---

Try 1. SELECT COUNT(*) FROM EMP, WORLD_EMP  WHERE EMP.EMP_ID = WORLD_EMP.EMP_ID; Try 2. SELECT COUNT(*) FROM EMP, WORLD_EMP  WHERE EMP.EMP_ID || '' = WORLD_EMP.EMP_ID; Try 3. SELECT /*+ index (world_emp pk_world_emp) */  COUNT(*) FROM EMP, WORLD_EMP
 WHERE EMP.EMP_ID || '' = WORLD_EMP.EMP_ID; May I know how to tune the SQL or other methods to use the remote index file.

Thanks!!

Regards,

Franco Received on Mon May 04 1998 - 17:24:30 CEST