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
|