Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 28 Jun 2003 @ 15:06:59 GMT


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


Subj:   AMP Scan?
 
From:   Charlie Briney

An NCR employee has told one of our consultants that the more tables there are on the disks owned by an AMP, the longer scans could take. The configuration at their site is using a MPP architecture.

Their statement seems to be implying that there are conditions where all the data owned by an AMP in a MPP architecture can be scanned by a single query.

How could scans take longer just because their is another table coexisting on the same disks an AMP owns, even if the additional table is not used? Is this even possible?



     
  <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