1. A computer implemented method for optimizing a query on a parallel computer system comprising the steps of: receiving a query to a database; checking a plan cache statistics table for information on networks involved in the query; where the query can be divided, checking other networks for availability and splitting the query to move a portion of the query to an available network; optimizing the query to split the query to use multiple networks using plan cache statistics from previously executed queries to determine whether to use multiple networks to optimize the query; and executing the optimized query.