SQL Performance (MOSC)

MOSC Banner

where does the JOIN happen when SELECT statement was executed thru DBLink?

edited May 10, 2016 8:47PM in SQL Performance (MOSC) 3 commentsAnswered ✓

Hi all,

My questions as titled.

For example,

1) select XXXX from TBL_A inner join TBL_B@dblink on TBL_A.id = TBL_B.id;

2) select XXXX from TBL_A@dblink inner join TBL_B@dblink on TBL_A.id = TBL_B.id;

According to my test result(thru explain plan), I see the JOIN happens in local site in 1), and in remote site in 2).

But there are no documents mention on this, so I have no idea whether it is the default behavior,

or it is decided by the optimizer.

Any advices are appreciated.

Regards.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center