Don,

The other thing you haven't mentioned is what your database workload is like. For example, if it is an OLTP system, you don't want a parallel process to max out the machine, but force all your other users to wait. On the other hand, for a DSS system, that may work just fine - the big query may be the one the boss needs and usage is pretty sporadic anyway.

 

Dennis Williams