Home Page for the TeradataForum

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


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)

  <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