Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 Sep 2009 @ 08:07:04 GMT

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

Subj:   Re: What if we use Fload or Mload for less than 10000 rows
From:   David Pracy

Question to consider :

What is the nature of the data that you are loading - is it all inserts or a mix of updates and inserts? - How unique is the data in general and the PI specificially?

Is the target table a SET table?

Are you using array support?

What is the pack factor?

How many sessions are you using?

Is the performance consistent? Ie if you ran the job 100 times whould you see the same thing?

Is the delay in the db? If so where?

What is the overall system performance?

  <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