Collecting Statistics on the PARTITION Column
PARTITION statistics are always collected for selected partitioned tables (row or column). Use the following query:
COLLECT STATISTICS COLUMN ("col_2",PARTITION) ON "<dbname>"."<table>"
Collecting Statistics on the Global Temporary Tables
Statistics are always collected on temporary tables. Use the following query:
COLLECT STATISTICS ON TEMPORARY <table name> <keyword> (<column name>)
Limitations on Column Types
Multi-column statistics are not allowed on GEOSPATIAL column types. If any column of type GEOSPATIAL type is selected, Add Multi Column is disabled for that column.
Statistics cannot be collected on columns of Type BLOB, CLOB, XML, JSON, PERIOD and User Defined Types.