Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 16 Aug 2006 @ 13:54:18 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Block size for Tactical Queries
From:   David Clough

If a particular table services both Decision Support (involving table scans) and Tactical Queries (hopefully not involving table scans), how best to design the block size ?

(Even though I seem to remember Stephen Brobst touching on this point at the Salzburg Tech conference, I can't for the life of me remember the detail.)

Is it best to have a small block size and rely on the automatic Table Scan 'scooping up' multiple blocks at one time approach, or should I rely on the fact that a non-Table Scan read would not even read the whole block size ?

I think I've just got a bit confused on how Decision Support and Tactical Queries coexist for the same table.

Thanks for expert replies.

Dave Clough
Database Designer
Express ICS


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020