DB2 Join query Vs COBOL Code

raghavmcs · Active User Joined: 14 Jul 2005 Posts: 105

I have a requirement, in that I have to extarct the data from 7 tables.

Here I have 2 options, I can write a DB2 Join query or write a COBOL program (First I will fetch the records from one table and then from the result of fisrt query need to fetch the data from 2nd table...so on till 7th table)

Perfromance wise which is better?

I am going to join the tables on indexed colmns only.

Pandora-Box · Posted: Mon Jun 16, 2014 5:33 pm Post subject:

Try an EXPLAIN

Also using Join could reduce the number of DB2 calls

Rohit Umarjikar · Posted: Tue Jun 17, 2014 12:32 am Post subject:

1) You can go for the DB2 unload utilities
2) Or if you have the load files for these tables then use SORT JOINKEY's instead of DB2 ( Best in performance)

roopannamdhari · New User Joined: 14 Sep 2006 Posts: 71 Location: Bangalore

Join consume more CPU.out of 2 option refer 2nd one .

Depending on requirement you can fine tune 2nd option

roopannamdhari · New User Joined: 14 Sep 2006 Posts: 71 Location: Bangalore

Join consume more CPU.out of 2 option refer 2nd one .

Depending on requirement you can fine tune 2nd option