Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2005 @ 12:52:17 GMT

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

Subj:   Re: Insert into empty table with statistics
From:   Victor Sokovin

  Statistics are ignored for the target table of SQL statements (certainly under V2R5).  

Dave, do you have a reference for this?

An obvious exception is recursive type of INSERT ... SELECTs where the table is both the target and a part of the source. Some developers even like them within one transaction. The situation I mentioned was one of those "chain" INSERT cases. Statistics did play an important and sometimes unpredictable role here. For not too large tables it definitely helped to have no stats at all.


  <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