Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 23 Feb 2011 @ 14:21:18 GMT

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

Subj:   Re: Collect Stats for INSERT/SELECT (no joins)
From:   David Clough

Hmm, oddly enough, I recently found that the Merge Statement was slower than the compound time taken for an equivalent Update (through a Join), followed by an Insert Where Not Exists.

I found that, where the Table was empty, sure enough the Merge was faster than the compound of the Update and Insert but, for populated Tables it was noticeably slower.

I'd be interested in others' experience because, based upon my very recent test (in V12), I'm suggesting we DON'T change our Load Scripts to a Merge Statement.


David Clough
Database Developer
Database Design Group

  <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