Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 18 Aug 2001 @ 17:13:20 GMT


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


Subj:   Re: CREATE TABLE AS???
 
From:   John Hall

Isn't it more likely, especially since defining a better index fixed the problem, that the machine was simply hot-AMPing? In that situation, the majority of the work is being performed by a single AMP (or just a few AMPs) and the benefit of parallel processing is completely lost. Compounding the performance penalty is the need to deal with hash synonyms and then finally, there's the impact of duplicate row checks - at that point, it's a pretty minor issue.



     
  <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