Hi, Just wandering which is better in term of performance U...

[NYCBabak .]

DB_LOOKUP isnt an appropriate substitute for a JOIN. I believe it should only be used under special situations where the look up data isnt in the same DBMS or looks up a couple of values rather than 1000s of rows.

[Nox Lee]

Hi,

Just wandering which is better in term of performance Using Join or DB_LOOKUP

Reason I ask is because I try both method for Table_A to have Table_Bs columns and DB_LOOKUP seem nothing is happen while Join I did see some DBMS I/O in Service Agents.

Or maybe I misunderstood boths use cases

My objective is to have a target with both Table_A and Table_Bs columns.

[Nox Lee]

Well, the data is much more than 10,000,000 rows so I guess DB_LOOKUP have some sort of limitation No wander it doesnt do anything while the agent is show running.