Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Parallel execution of Queries
 
From:   Bhakti Ulhas Bongale

Hi,

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?


Regards,

Bhakti Bongale



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