Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 29 Jun 2004 @ 16:44:26 GMT


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


Subj:   Re: Teradata and ODS
 
From:   Ballinger, Carrie

Sid,

Here's a few suggestions for implementing those types of applications on a Teradata platform:

-- Enhancements in the V2R5.0 release will be a benefit

-- Localize the database access to one or few AMPs

-- Check explain text to make sure you are getting row level locks, no table level locks

-- Consider access locking, if appropriate (row level access locking)

-- Design for parameterized SQL and cached plans

-- Smaller blocksizes are preferable

-- Be aggressive with workload management techniques

-- Consider reserving AMP worker tasks only if that's the proven bottleneck, and other techniques offer no relief

-- Avoid Access Logging if possible for such requests, use DBQL Summary level logging as an alternative


You might not know about this unless you were looking for it, but Chapter 17 (Design Issues for Tactical Queries) in the current Database Design manual (B035-1094-083A) covers these points and others in greater detail.


Thanks, --Carrie



     
  <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