Archives of the TeradataForum
Message Posted: Sun, 03 Nov 2002 @ 13:48:53 GMT
As well as the comments made by Dennis, one thing that you may want to review is your choice of indexes in yuor Teradata 'implementation' of these tables.
I've worked with many customers who have tried to do what you have done by simply copying the table definitions across from another dbms into Teradata. One of (many) major dfferences between Teradata and other dbms offerings is the way that indexes are used/not used by the optimiser.
From what you've said, the indexes that you currently have are optimised for SQL Server but they may be causing unnecessary work for Teradata. You'll need to check the explain output to determine that.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023