Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 01 Aug 2006 @ 14:27:27 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Parallel execution of Queries
From:   Bhakti Ulhas Bongale


Consider the following two scenarios:

1) There is a single session of a user. The user executes two queries in a parallel fashion.

2) There are two sessions of the same user. Two queries are executed separately in the two sessions. These queries are submitted with, say, a very negligible time difference.

Which one of the two scenarios would return the results faster?

Also, which one will consume fewer resources?

Will there be any difference in the spool space consumed?


Bhakti Bongale

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020