| Need An Alternate - Synonyms [message #144588] |
Thu, 27 October 2005 05:33  |
|
|
Hi All,
I have a synonym x for a remote database table y. Something like "create synonym x for y@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
|
|
|
|
|
|
| Re: Need An Alternate - Synonyms [message #144647 is a reply to message #144628] |
Thu, 27 October 2005 09:54  |
|
|
Hi Frank,
Thanks for ur reply!! I have already tried ur suggestion, but that is resulting in serious performance issues as views work badly when used in subqueries at multiple levels.
Please suggest an alternate to this.
Regards,
RP
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
