bhushan.shete
New User
Joined: 14 Nov 2006 Posts: 17
|
|
|
|
Hi All,
I have 2 tables say EMP and EMPATTRIB, both have primary key as EMPNO.
In COBOL program, i want to access couple of columns from each of these tables having one to one relationship.
Which of below option is efficient?
1) Using inner join on these 2 tables, so sql request will be once.
2) Using 2 different select queries one after another, join overhead will be reduced.
Both tables are indexed on EMPNO, each table have 30 Million rows.
I tried to search in forum, but could not found similar problem. Any pointers to findout which one is efficient would be also helpful.
Thank you
Bhushan |
|