RE: SMP experiences

So if I understand correctly what I have read and what you are telling me we
are getting some boost from optimized I/O but could see improved performance
by adding CPU parallelism because there is also a CPU component to the index
maintenance.  Additionally any CPU work that could be split into parallel
tasks would also benefit.


-----Original Message-----
From: Elvis Budimlic [mailto:ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, June 24, 2003 12:52 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SMP experiences


> Are we already getting the benefit of parallel index maintenance or 
> should it be changed to something else?  

I/O setting will have system optimize disk I/O utilization but not CPU,
so let me tender a qualified yes.  Index maintenance is being helped in
a sense that I/O is being optimized, but you are not taking advantage of
CPU parallelism.

> Am I missing something?

No, you are not missing anything.  Your statements are correct, *MAX is
"mine is the only work that matters" and *OPTIMIZE is "I matter, but so
does other work".