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?