Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Performance using db_link
I have a schema which will be migrating to a new data model and even to
a new instance on a different operating system. Because we have many
legacy applications accessing this schema, we still need to support the
old table objects.
Right now I have 2 options on the table:
1 - create a public synonym, "old_schema.table", in the old instance which points to: new_schema.view_at_db_link_to_new_instance
OR
2 - create a view in the old instance which is:
select * from new_schema.view_at_db_link_to_new_instance
If I do a simple select of 1 column using both options, it takes more than 5 minutes to retrieve the 1 record. The views in the new schema are very complex and I believe that is where I should focus my tuning. Which option listed above is "standard" ?
TIA,
Cliff
The contents of this message express only the sender's opinion. This message does not necessarily reflect the policy or views of my employer, Merck & Co., Inc. All responsibility for the statements made in this Usenet posting resides solely and completely with the sender.Received on Tue Aug 10 1999 - 13:33:38 CDT
![]() |
![]() |