DBA_AIM_PERF_FEATURES
DBA_AIM_PERF_FEATURES describes table columns on which Automatic In-Memory (AIM) performance features are enabled.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER_NAME |
VARCHAR2(128) |
NOT NULL |
Table owner |
TABLE_NAME |
VARCHAR2(128) |
NOT NULL |
Table name |
COLUMN_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the column on which AIM performance features are enabled |
OPTIMIZED_ARITHMETIC |
CHAR(1) |
Indicates whether the column is optimized for arithmetic operations (Y) or not (N) |
|
BLOOMFILTER_OPTIMIZATION |
CHAR(1) |
Indicates whether queries on the column use cached hash values to probe the bloom filter during hash joins (Y) or not (N) |
|
VECTOR_OPTIMIZATION |
CHAR(1) |
Indicates whether data is stored in the column using vector optimization (Y) or not (N) |
|
JOIN_GROUP |
CHAR(1) |
Indicates whether the column is part of a join group that was created by AIM (Y) or not (N) |
|
CREATION_DATE |
DATE |
Date and time at which the AIM performance features were implemented |
Note: This view is available starting with Oracle AI Database 26ai.