remote query - join is slow

[ija]

Hi.

Join on two tables in different databases is terribly slow. Some ideas, what to do?

We have two tables in two different databases, each with about 4 milions records. When we do a select on them retrieving about 100 records from each (it is contact and address), it runs longer then we have ever waited. We used a cursor and variable, which we sent into the remote query, but it is still slow and we would like to avoid the cursor anyway...

 

[sem]

Try to chose local table as a driving in nested loop using hint. You may also try to use DRIVING_SITE hint

 

[ija]

I wondered, why the DRIVING_SITE hint did not work. I mistyped it...

Thanks, now it is quite fast.