The following examples collect statistics on the system-derived PARTITION column for the table named table_1.
For the second statement, the system ignores your request for sampled statistics and uses a value of 100 percent, because you cannot collect sampled statistics on a system-derived PARTITION column
COLLECT STATISTICS ON table_1 COLUMN PARTITION; COLLECT STATISTICS USING SAMPLE table_1 COLUMN PARTITION;