Re: Parallel execution strategy

From: Frank van Bortel <>
Date: Mon, 17 Mar 2008 21:32:58 +0100
Message-ID: <3019a$47ded57b$524b5c40$> wrote:
> Hi all,
> A customer of mine is facing performance problems caused by bad single
> physical read rates. I'm working on the root cause. In the meanwhile
> I'm going to implement parallel execution since all resources on these
> servers are underused and there are just a few concurrent users all
> day long. With parallel execution enabled, the physical read rate for
> most queries with lots of gets is dramatically increased.
> Any advice regarding the strategy to get the best results? Forcing
> parallel query/dml/ddl at the session level is no option (I've tried
> this out on a test plateform with very bad results such as application
> errors and, as expected, very long execution times for queries not
> benefiting from parallel execution.)
> I'm currently identifying every queries with a bad read rate and a
> long execution time and I'm implementing parallel execution on the
> underlying objects (by testing each query on a test plateform). But
> this is somewhat time-consuming. ;-)
> TIA,
> Jerome

Warning: ROT ! Warning: ROT!

Try to change "large" table to parallel. You will need to find out what large means in your case; I've never seen anything benefit from parallel queries when less than a couple of hundred thousand records need to be processes.
Anything short of that, and the overhead on parallel processes is more than the benefit.
You may also want to play with the number of parallel processes

Again: Rule-Of-Thumb warning!

DO NOT take this for granted!


Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Mon Mar 17 2008 - 15:32:58 CDT

Original text of this message