15.00 - Cumulative Number of Data Block Read I/Os as a Function of Duplicate NUPI Inserts - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Cumulative Number of Data Block Read I/Os as a Function of Duplicate NUPI Inserts

A log-log plot of the data from the preceding table indicates extremely exponential growth in the cumulative number of data block read I/Os required to process duplicate NUPIs as a function of the number of duplicate NUPI rows on the AMP. Notice that these are data block reads, not individual row reads. For example, if there are 100 rows in a given data block, only one data block read is required to retrieve all 100 rows.