|
Column name
|
Data type
|
Description
|
|---|---|---|
|
BASE_TABLE_ID
|
INTEGER
|
Internal identification number of the table with cache segment assignments
|
|
CACHE_SEGMENT_
NAME |
WVARCHAR
|
Name of the cache segment to which the table or data range is assigned
|
|
COLUMN_NO
|
INTEGER
|
Internal identification number of the column with cache segment assignments
|
|
CONDITION
|
WVARCHAR
|
Type of range specification
Possible values are:
<
> = <> BETWEEN ... AND OLDERTHAN ... DAYS OLDERTHAN ... SECONDS NEWERTHAN ... DAYS NEWERTHAN ... SECONDS |
|
VALUE1
|
WVARCHAR
|
First value in the range specification
|
|
VALUE2
|
WVARCHAR
|
Second value in the range specification if CONDITION is BETWEEN
|