Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 31 Jan 2007 @ 17:18:41 GMT

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

Subj:   Re: Gathering statistics within a transaction
From:   Victor Sokovin

  We are porting over a couple of hundred procedures from SQL Server to Teradata so re-writing them all so that we update these tables in one procedure and collect stats at the end of it and then use them in other procedure isn't an option for us.  

COLLECT STATISTICS is a DDL statement so it will always end the transaction.

You can test whether you really need to collect stats in Teradata as often as you do in SQL Server. Despite the undeniable recent progress of the latter these two databases are still in different leagues.

Also, I don't think it makes sense to "port" procedures without re-thinking all their logic. Procedures in SQL Server might become something totally different in TD.



  <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