Column‑Partitioned Single‑Table Join Indexes
You can create column‑partitioned single‑table join indexes with the following restrictions.
Column‑partitioned join indexes are designed to support requests that very selectively access a variable small subset of the columns and rows, either in predicates or as column projections.
The Optimizer can also use column‑partitioned join indexes to support direct access to a column‑partitioned table using a RowID join.
See “CREATE JOIN INDEX” in SQL Data Definition Language for more information about column partitioning and single‑table join indexes.