Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB Links vs Synonym

user521009Nov 7 2008 — edited Nov 7 2008
Hi I have a quick question; I have to join schema_1.table_1 to schema_2.table_2 but they are in different databases db_1 and db_2. I noticed that there is a dblink from schema_1.table_1 to schema_2.table_2.db_2.

But would that affect my performance if i join using dblink?
Would creating a Public synonym for the schema_2.table_2 help me in performance....Any other workarounds????

Maybe an Index on that joining column might help me in performance? Should i create the Index in database_1 or Database_2????


Thanks,
Kon
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2008
Added on Nov 7 2008
2 comments
328 views