Archives of the TeradataForum

Message Posted: Sun, 03 Nov 2002 @ 13:48:53 GMT


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

Subj:		Re: Does Teradata have anything similar to Procedural caching (supported with SQL Server)

From:		David Wellman

Bhupesh,

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.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)