in different database server processes 116 and may for example be spread throughout a cluster in a clustered database architecture the database server 206 may identify portions of the query plan that may be executed in parallel by for example accessing table partitions and intermediate sorts and schedule them to run in parallel the final results may be delivered to the root node 208 which is associated with the initiator session 202 steps 430 440 fig3 and 4b illustrate an exemplary method and system 200 for a number of consumer sessions 214 to receive parallel result streams in response to the query requested in fig2 while the prior art delivered final query results in a serial manner the exemplary system 200 may deliver query results in a parallel manner this may facilitate faster data movement for some data warehouse applications such as for example parallel extract transform load etl jobs using the initiator session 202 the application 110 may submit a query request which may include a desired number of parallel result streams to the database server 206 the workstation 204 and the database server 206 may communicate to create a number of consumer sessions 214 in the application 110 with access to parallel result streams from the top level nodes 210 where the access may be through a number of root nodes 208 the access to the parallel result streams may be provided with various security mechanisms the initiator session 202 may send authentication information from the database server 206 to the consumer sessions 214 to be used to access the result streams the consumer sessions 214 may share the transactional context of the initiator the system 200 may allow users to.