Statement Memory Configuration 326 Resource Queue Spill File Configuration 327 Schema Design 328 Schema Design 0 Data Types 328 Use Types Consistently 328 Choose Data Types that Use the Least Space Partition Strategy 749 Troubleshooting Selective Partition Scanning 750 Viewing Your Partition Design 750 Maintaining Partitioned Tables 751 Adding a Partition 752 Renaming a Partition 752 Adding 1000 Tuning Statistics Collection 1000 Optimizing Data Distribution 1001 Optimizing Your Database Design 1001 Greenplum Database Maximum Limits 1001 Greenplum Database Memory Overview 1002 Greenplum

Statement Memory Configuration 335 Resource Queue Spill File Configuration 336 Schema Design 337 Schema Design 0 Data Types 337 Use Types Consistently 337 Choose Data Types that Use the Least Space Partition Strategy 758 Troubleshooting Selective Partition Scanning 759 Viewing Your Partition Design 759 Maintaining Partitioned Tables 760 Adding a Partition 761 Renaming a Partition 761 Adding 1009 Tuning Statistics Collection 1009 Optimizing Data Distribution 1010 Optimizing Your Database Design 1010 Greenplum Database Maximum Limits 1010 Greenplum Database Memory Overview 1011 Greenplum

Statement Memory Configuration 260 Resource Queue Spill File Configuration 260 Schema Design 261 Schema Design 0 Data Types 261 Use Types Consistently 261 Choose Data Types that Use the Least Space Partition Strategy 681 Troubleshooting Selective Partition Scanning 682 Viewing Your Partition Design 682 Maintaining Partitioned Tables 683 Adding a Partition 684 Renaming a Partition 684 Adding 934 Tuning Statistics Collection 934 Optimizing Data Distribution 935 Optimizing Your Database Design 935 Greenplum Database Maximum Limits 935 Greenplum Database Memory Overview 936 Greenplum Database

Resource Queue Statement Memory Configuration 330 Resource Queue Spill File Configuration 331 Schema Design 332 Data Types 332 Use Types Consistently 332 Choose Data Types that Use the Least Space 332 Partition Strategy 748 Troubleshooting Selective Partition Scanning 748 Viewing Your Partition Design 748 Maintaining Partitioned Tables 749 Adding a Partition 750 VMware Tanzu Greenplum v6.20 Documentation 1000 Tuning Statistics Collection 1000 Optimizing Data Distribution 1000 Optimizing Your Database Design 1001 Greenplum Database Maximum Limits 1001 Greenplum Database Memory Overview 1001 VMware Tanzu

Partition Strategy 356 Troubleshooting Selective Partition Scanning 357 About Viewing Your Partition Design 357 Viewing a Classic Syntax Sub-Partition Template 358 Constructing a pg_partitions-Equivalent 965 Tuning Statistics Collection 965 Optimizing Data Distribution 966 Optimizing Your Database Design 966 Greenplum Database Maximum Limits 966 Greenplum Database Memory Overview 967 Segment Host Resource Queue Statement Memory Configuration 1021 Resource Queue Spill File Configuration 1022 Schema Design 1023 Data Types 1023 Use Types Consistently 1023 Choose Data Types that Use the Least Space 1023

Partition Strategy 587 Troubleshooting Selective Partition Scanning 588 Viewing Your Partition Design 588 Maintaining Partitioned Tables 588 Adding a Partition 589 VMware Greenplum 6 Documentation 1178 Tuning Statistics Collection 1178 Optimizing Data Distribution 1179 Optimizing Your Database Design 1179 Greenplum Database Maximum Limits 1179 Greenplum Database Memory Overview 1180 Segment Host Resource Queue Statement Memory Configuration 1240 Resource Queue Spill File Configuration 1241 Schema Design 1242 Data Types 1242 VMware Greenplum 6 Documentation VMware by Broadcom 59 Use Types Consistently

Partition Strategy 581 Troubleshooting Selective Partition Scanning 582 Viewing Your Partition Design 582 VMware Greenplum 6 Documentation VMware, Inc 24 Maintaining Partitioned Tables 583 Adding 1163 Tuning Statistics Collection 1163 Optimizing Data Distribution 1163 Optimizing Your Database Design 1164 Greenplum Database Maximum Limits 1164 Greenplum Database Memory Overview 1164 Segment Host Resource Queue Statement Memory Configuration 1223 Resource Queue Spill File Configuration 1224 Schema Design 1224 Data Types 1225 Use Types Consistently 1225 Choose Data Types that Use the Least Space 1225

Partition Strategy 560 Troubleshooting Selective Partition Scanning 561 Viewing Your Partition Design 561 Maintaining Partitioned Tables 561 Adding a Partition 562 Renaming a Partition 563 Adding 1127 Tuning Statistics Collection 1127 Optimizing Data Distribution 1127 Optimizing Your Database Design 1127 Greenplum Database Maximum Limits 1128 Greenplum Database Memory Overview 1128 Segment Host Resource Queue Statement Memory Configuration 1184 Resource Queue Spill File Configuration 1185 Schema Design 1185 Data Types 1185 Use Types Consistently 1186 Choose Data Types that Use the Least Space 1186

Partition Strategy 557 Troubleshooting Selective Partition Scanning 558 Viewing Your Partition Design 558 Maintaining Partitioned Tables 559 Adding a Partition 559 Renaming a Partition 560 VMware 1122 Tuning Statistics Collection 1122 Optimizing Data Distribution 1122 Optimizing Your Database Design 1123 Greenplum Database Maximum Limits 1123 Greenplum Database Memory Overview 1123 Segment Host Resource Queue Statement Memory Configuration 1179 Resource Queue Spill File Configuration 1180 Schema Design 1180 Data Types 1181 Use Types Consistently 1181 Choose Data Types that Use the Least Space 1181

Partition Strategy 558 Troubleshooting Selective Partition Scanning 559 Viewing Your Partition Design 559 Maintaining Partitioned Tables 559 Adding a Partition 560 Renaming a Partition 561 Adding 1146 Tuning Statistics Collection 1146 Optimizing Data Distribution 1147 Optimizing Your Database Design 1147 Greenplum Database Maximum Limits 1147 Greenplum Database Memory Overview 1148 Segment Host Resource Queue Statement Memory Configuration 1208 Resource Queue Spill File Configuration 1209 Schema Design 1210 Data Types 1210 Use Types Consistently 1210 Choose Data Types that Use the Least Space 1210