Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 11 Nov 2003 @ 16:05:54 GMT


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


Subj:   Re: MLoad performance
 
From:   Agarwal, Rachana

The problem is in the application phase

I think I got one of the possible reasons... and that is Primary index defined on the table. That has very less unique values.

And that may cause amp to not able to decide in a proper way.

There are no records in the error table.

We have not specified any session values in our scripts.

Checkpoint - 25,000
AMP's - 8


Thanks

Rachana



     
  <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