I suppose I was quite ambigeous in that post.
I wans't referring to SMP hardware. I was referring to SMP parallelism
within a user connection. "intra-query"
This is a different way of exploiting SMP than say, for concurrency to
scale number of users.
I can't talk for Oracle of course, but DB2 runs with "intra-query"
parallelism OFF in TPC-C and to the best of my knowledge (which is
limited) this is true for many real world OLTP applications using DB2.
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Received on Thu Jun 24 2004 - 07:48:19 CDT
