2.7.5 Auto Data Placement

2.7.5.1 Running Auto Data Placement

2.7.5.2 Auto Data Placement Examples

Auto Data Placement generates data placement key recommendations. Data placement keys are used to partition table data among HeatWave nodes when loading tables. Partitioning table data by JOIN and GROUP BY key columns can improve query performance by avoiding costs associated with redistributing data among HeatWave nodes at query execution time. The Data Placement Advisor generates data placement key recommendations by analyzing table statistics and HeatWave query history. For more information about data placement keys, see Section 2.7.2, “Defining Data Placement Keys”.