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.
|