remote join problem

We are having problems with remote joins being executed locally. For example query (l1 is a private database link)  

SELECT count(*)
FROM t1_at_l1 t1,

     t2_at_l1 t2
WHERE t1.c1 = t2.c2;  

will be parsed as follows:

1. SELECT c1 FROM t1_at_l1;
2. SELECT c2 FROM t2_at_l1;
3. local join of results and count
 

What we'd like is to have the join performed on the remote database and only the final results send across the network. We are running 7.1.6.2 on both databases. We don't want to create views on the remote database to hide joins since we are running an ad hoc query environment with too many possible join combinations.  

Thanks
Petr Schmidt
pgschmid_at_bcsc02.gov.bc.ca Received on Wed Feb 21 1996 - 00:00:00 CET