Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 27 Nov 2007 @ 21:16:55 GMT

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

Subj:   Re: Statistics in BT; ET;
From:   Anomy Anom

<-- Anonymously Posted: Tue, 27 Nov 2007 13:59 -->

No, the bottom line is:

1) COLLECT STATISTICS is currently considered DDL, which means it must be the last or only statement in a transaction.

2) Some future release of Teradata might include changes to allow COLLECT STATISTICS to be considered DML. It's good that someone is thinking about it, but there are no promises that it will be in TD13.x.

  <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