Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 24 Aug 2006 @ 15:25:36 GMT


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


Subj:   Re: Updates versus Delete/Insert
 
From:   Diehl, Robert

Dave,

Have never really done bench marking on this scenario?

While you are at it you should also try the upsert statement.

I assume collocated means same primary index. Is this correct?

Are you updating the primary index column? Try not updating the primary index column/columns.

Was the table contents the same before each test?

Was the system load identical?

A couple of seconds in my book is the same until you test the scenario many times as there can be other things happening on the system as it may even out noise from other factors.


Thanks,

Bob Diehl



     
  <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