Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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

www.tnt.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