View previous topic :: View next topic
|
Author |
Message |
bipinpeter
Active User
Joined: 18 Jun 2007 Posts: 213 Location: Cochin/Kerala/India
|
|
|
|
Hi All,
I want to extract data from one table by joining with other table.Which utility is good for my requirement.I have DSNUPROC & DSNTIAUL utilities in my shop. In performance wise which will be better.
Regards,
Bipin Peter |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
DSNTIAUL would be fine as u need to join 2 tables.... Make sure you use proper join clause and filter predicates to avoid tablespace scan. |
|
Back to top |
|
|
bipinpeter
Active User
Joined: 18 Jun 2007 Posts: 213 Location: Cochin/Kerala/India
|
|
|
|
Thanks gylbharat for the information |
|
Back to top |
|
|
|