Search found 1 match
- Thu Dec 03, 2009 2:58 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Multiple Select Queries vs Single Join Query
- Replies: 1
- Views: 5325
Multiple Select Queries vs Single Join Query
Hi, Which one of the 2 approaches below is better provided indexes are availabe on the columns - id & dno in respective tables. select f.dno, d.dname, c.sname.... into :f-dno, :d-dname, :c-sname... from faculty f, dept d, stud s where f.dno = d.dno and f.dno = s.dno and f.id = :host-var-fac-id -----...