Hello,
Oracle 8.1.6 on Solaris 2.7.
Can any one provide me with information or a link regarding
performance of views across database links?
I am thinking of the case where instance A has a view defined
as SELECT FLD1,FLD2,... FROM TABLE_T1@DBLINK.
Consider the case when a view such as this is
Bill,
I too would love to hear from better experts than me.
I also have implemented queries using db links.
In my rudimentary testing, I found that you need to create the view on the
remote machine to get any decent kind of performance, and then access that
view thru the db link. My guess as a
