Manage I/O with Cylinder Read | Teradata Vantage - Managing I/O with Cylinder Read - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

A data block is a disk-resident structure that contains one or more rows from the same table and is the smallest I/O unit for the file system. Data blocks are stored in physical disk sectors or segments, which are grouped in cylinders.

Vantage employs Cylinder Read to enable full-file scan operations to run more efficiently by reading a list of cylinder-resident data blocks with a single I/O operation. This reduces I/O overhead from once per data block to once per cylinder. This can significantly reduce the time it takes to do a full-table scan of large tables. During installation, Cylinder Read is enabled by default.

If you notice a performance hit from Cylinder Read, try decreasing the value of the Cylinder Read Aging Threshold control field in the Ctl DBS screen. For information on this field, see Teradata Vantage™ - Database Utilities, B035-1102.
Cylinder Read may improve performance during operations such as:
  • Full-table scan operations under conditions such as:
    • Large select
    • Merge INSERT ... SELECT
    • Merge delete
    • Sum, average, minimum, maximum, and count aggregates
  • Joins operations that involve many data blocks, such as merge or product joins.

Cylinder reads are not invoked when there is row partitioning elimination or column partitioning elimination.

For more information, see Managing I/O with Cylinder Read.