DB Links vs Synonym
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