Need an alternate - SYNONYMS

Hi All,
I have a synonym x for a remote database table y. Something like "create synonym x for y_at_remote_dblink".

With the change in design, my requireent is to have a similiar synonym representing the UNION of two tables y and Z from the remote database. Tables Y and Z are on the same instance but on different schema. I have created two db links for the same.

Can anyone suggest me as to how do I do that without affecting the performance??

I tried one method, wherein I created a view on the union of 2 remote tables and then created a synonym with the same name x on this view. But this design gives me serious performance issues when the synonym is used in subqueries at multiple levels.

Please advise me on this.

Regards,
rp Received on Thu Oct 27 2005 - 07:54:09 CDT