> Do you know of any RDBMS that actually will execute a single query on
> multiple processors?
SQL Server does in a sense. It can split a query onto multiple threads
(which could possible use multiple processors) and then brings the results
from the threads into one and then sends the results to the client.