rpd_preload_stats table stores column
level statistics collected from
tables. The statistics are used to estimate the number of
HeatWave nodes required for a given dataset before loading the
tables into the HeatWave Cluster.
rpd_preload_stats table has these
The schema name.
The table name.
The column name.
The average byte width of the column. The average value includes NULL values.
rpd_preload_stats table has the
It is read-only. DDL, including
TRUNCATE TABLE, is not permitted.
It is truncated before new statistics are added.
It cannot be dropped, truncated, or modified by DML statements directly.
Statistics are not persisted when the server is shut down.
It has a limit of 65536 rows.
Statistics are approximate, based on an adaptive sample scan.
Statistics are deterministic, provided that the data does not change.