Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 09 Apr 2007 @ 23:28:14 GMT


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


Subj:   Re: Merging large volumes of data into large history tables
 
From:   bob hahn

Quoting Todd Walter, "I always point out that people's assumptions about the TJ are becoming false."

V2R6 fixed the long rollback cases except NUSI, and 6.2 fixed NUSIs. That relieves the #1 TJ issue which is long rollback. (DR 97223 Block Optimized NUSI rollback also DR 66973 Block Optimized USI maintenance and rollback).

Insert/update operations have been made performant enough that the can be done with TJ for consistency and still hit performance levels like MLoad.

There are further enhancements to bulk MERGE in 12.0.



     
  <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