Distributed Tables

360 Zhihui Cloud Developer

Mar 9, 2017 · Databases

Master Greenplum Table Design & Performance Optimization: Practical Tips

This article explains what Greenplum is, its MPP shared‑nothing architecture, and provides concrete table‑design principles, distribution‑column strategies, indexing guidance, vacuum and table‑rebuilding techniques, as well as SQL, join, insert, update/delete, and resource‑queue optimizations for better performance.