![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Thu, 05 Aug 2004 @ 09:07:48 GMT
Subj: | | Cylinder Read vs MAXBLOCKSIZE |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, August 04, 2004 18:47 -->
In V2R5 you can enable Cylinder Read, which increases I/O efficiency during full table scans of large tables (and other operations). Prior to
V2R5, you could increase I/O efficiency of full table scans by creating tables with a large MAXBLOCKSIZE. If you enable CR in V2R5, does this, in
effect, make the MAXBLOCKSIZE parameter irrelevant?
| |