Group the values from the specified column set of 1 or more columns into the same partition of a column-partitioned table. You can specify a single column in a partition.
This option is only valid for column-partitioned tables.
You should consider grouping columns into a column partition when either of the following conditions occur:
- The columns are frequently accessed together by queries.
- The columns are infrequently accessed or autocompression on the individual columns or subsets of columns is not effective.
You cannot specify a column to be in more than one partition.
If you do not specify a column grouping for a COLUMN specification in the PARTITION BY clause, Vantage defines a column partition for each individual column and column group specified in the column list for table_name.