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

    Databaselink phenomenon




      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 :-)