Archives of the TeradataForum
Message Posted: Wed, 16 Aug 2006 @ 13:54:18 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|