View previous topic :: View next topic
|
Author |
Message |
magesh23586
Active User
Joined: 06 Jul 2009 Posts: 213 Location: Chennai
|
|
|
|
Rohit,
Check the spool for Joinkey, you will see three outputs.
Code: |
SYSOUT
JNF1JMSG
JNF2JMSG
|
JNF1 => 1 Pass.
JNF2 => 1 Pass.
After Join => 1 pass.
ideally any DFSORT Joinkey will have three pass irrespective of JNF1CNTL/JNF2CNTL statements.
In SYMNAMES solution we have only two pass. |
|
Back to top |
|
|
chandan.inst
Active User
Joined: 03 Nov 2005 Posts: 275 Location: Mumbai
|
|
|
|
Nice explanation Mangesh..
I agree with you regardless of volume of data Joinkeys will degrade the performance and it is best practice to use performance efficient code though the impact is minimal
Thanks,
Chandan |
|
Back to top |
|
|
|