Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 May 2004 @ 11:53:26 GMT


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


Subj:   Parallelism vs. Oracle
 
From:   Jebaseelan_S

Hi All,

Can somebody describe the following statement interms of Oracle Query Processing.

1.Select * from TableA; (Table A has a unique Primary Key )

From Teradata Point As TableA has a unique PK the request will be sent to all AMP , and the records referred by each AMP for this TableA will be fetched in parallel without any HOTAMPs .

What is the case in Oracle ??


2. What if I have a where clause on the PK column in the above select .

From the Teradata Point I understand it is going to be only one or some AMP that is going to work out this .

In this case Which is deciding that which AMP(s) should work out this??

If it is PE... has PE know all information about what all the AMP has

What is the case in Oracle ??


3. What if I have a where clause on the Non Unique column in the above select ?

Both Oracle and Teradata Perspetive ...



     
  <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: 27 Dec 2016