11 Replies Latest reply: Mar 13, 2014 9:28 AM by Paul Horth RSS

    Databaselink phenomenon

    boffman

      Hi,

       

      I've following situation:

       

      I'm running a procedure of a database package which generates in a dynamic SQL a Select statement joining two tables. These two tables are using either one or two databaselinks. In case of using two databaselink, one is a loop-back databaselink. The phenomenon is, if I generate it with the loop-back databaselink the query is ten times faster?!

       

      Can anybody please explain that to me :-)

       

      cheers,

      Bernhard