Archives of the TeradataForum
Message Posted: Wed, 31 Jan 2007 @ 17:18:41 GMT
| 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.
Regards,
Victor
| 
