The column partition containing the column uses COLUMN format, if it is not already defined with COLUMN format.
You can include columns in the join index with a data type of non-LOB XML, non-LOB ST_GEOMETRY, non-LOB JSON, and non-LOB DATASET. However, you cannot include these data types in the primary index of a join index.
A column in a join index cannot have a data type of BLOB, CLOB, BLOB-based UDT, CLOB-based UDT, VARIANT_TYPE, ARRAY, VARRAY, LOB XML, LOB ST_GEOMETRY, LOB JSON, or DATASET LOB.
- AUTO COMPRESS
- The column partition containing the column use COLUMN format with autocompression.
- NO AUTO COMPRESS
- The column partition containing the column use COLUMN format without autocompression.