By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

Performance of JOIN vs. singleton SELECTs

P: 1
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
Share this Question
Share on Google+
1 Reply


P: 20
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.