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>>