I'm trying to select several 1000 rows from a remote database (where I can change nothing). I have (string) IDs to filter the needed data rows but I'm having performance issues.

Using a simple sql select I can retrieve the data in ~4 s.
`

```
SELECT
    myid,
    column2
FROM
    view1@remotedb
WHERE
    myid IN ( '1', '2', '3' )

```

`

Since I need to select several thousand rows I'm using a local database for the IDs to select.
`

```
SELECT /*+DRIVING_SITE(V1)*/ myid,
    column2
FROM
    view1@remotedb    v1,
    localdb           t1
WHERE
    v1.myid = t1.myid;

```

`
Unfortunately even for only 3 IDs in t1 the execution time increases to 3 min. Using driving\_site or not makes no difference. Is there a way to increase the performance?