467,209 Members | 1,293 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

Performance of JOIN vs. singleton SELECTs

DB2 v8 for z/OS
Data for each employee is spread across 12 tables.
We are accessing 12 tables with each table having from zero to one row per employee, except the first table has a required row for each employee.

What is the percentage of improvement if we do a JOIN of all 12 tables using
LEFT OUTER JOIN
vs. coding 12 singleton SELECTs ?

What if we have 5 tables in the above example ?
Aug 6 '07 #1
  • viewed: 1523
Share:
1 Reply
There is no simple answer to this question. In theory there will be significant improvement if you have one statement as opposed to 12 statements, but there's no real way we can figure out a percentage without more information. Table statistics, parallelism on/off, etc etc.
Aug 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by inna | last post: by
1 post views Thread by Bruce Hendry | last post: by
3 posts views Thread by Robert Stearns | last post: by
9 posts views Thread by deko | last post: by
3 posts views Thread by HL | last post: by
4 posts views Thread by skotapal@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.