prefetch

Description

Specifies the I/O size to use for the scan of a stored table.

Syntax

( prop table_name
          ( prefetch size  )
)

Parameters

table_name

is the table to which the property is to be applied.

size

is a valid I/O size: 2, 4, 8 or 16.

Examples

Example 1

select * from t1

( prop t1
    (prefetch 16 )
)

16K I/O size is used for the scan of t1.

Usage

See also

prop