Vacuum and Analyze for Query Optimization
Greenplum Database uses a cost-based query planner that relies on database statistics. Accurate statistics allow the query planner to better estimate selectivity and the number of rows that a query operation retrieves. These estimates help it choose the most efficient query plan. The ANALYZE command collects column-level statistics for the query planner.
You can run both VACUUM and ANALYZE operations in the same command. For example:
=# VACUUM ANALYZE sales_data;