Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 29 Nov 2011 @ 15:21:50 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Sessions and AMP interaction
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, November 29, 2011 10:16 -->


I have just started working on Teradata database. have lot of questions on how it works backend and how it interacts with other ETL Tools.

My Question is When we run any query with more than one session how it interacts with AMP's.


     Select * from Table1 where ColumnName='USA'.

So, the appropriate AMP will be activated and retrieves the data if it is single Session. When we run more than one session how it works?

If two persons run a same query at the same time as above on Teradata, how the AMP will react?


  <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