Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 05 Jul 2005 @ 17:46:43 GMT

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

Subj:   Re: Transaction Rollback
From:   Mogilevsky, Boris


I can comment on of one of your questions(4) based on my personal experience. When you want to do any DML operations try use MULTILOAD, FASTLOAD, EXPORT , FASTEXPORT utilities rather than working with SQL statements in BTEQ. That is always much more efficient. I have changed a process from BTEQ to MULTILOAD insert/delete combination and the CPU time has decreased 50% !!

Boris Mogilevsky
Programmer Analyst

  <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