Greenplum Database Best Practices 0 Best Practices Summary 324 Best Practices Summary 0 Data Model 324 Heap vs. Append-Optimized Storage 324 Row vs. Column Oriented Storage 324 Compression 325 Data Types 337 Use Types Consistently 337 Choose Data Types that Use the Least Space 337 Storage Model 337 Heap Storage or Append-Optimized Storage 338 Row or Column Orientation 338 Compression 339 Hash Operator Class 736 Choosing the Table Storage Model 738 VMware Greenplum v6.19 Documentation VMware, Inc. 42 Choosing the Table Storage Model 0 Heap Storage 738 Append-Optimized Storage 739

Greenplum Database Best Practices 0 Best Practices Summary 315 Best Practices Summary 0 Data Model 315 Heap vs. Append-Optimized Storage 315 Row vs. Column Oriented Storage 315 Compression 316 Data Types 328 Use Types Consistently 328 Choose Data Types that Use the Least Space 328 Storage Model 328 Heap Storage or Append-Optimized Storage 329 Row or Column Orientation 329 Compression 330 Hash Operator Class 727 Choosing the Table Storage Model 729 VMware Greenplum v6.18 Documentation VMware, Inc. 41 Choosing the Table Storage Model 0 Heap Storage 729 Append-Optimized Storage 730

Distribution Key Hash Functions 538 Example Custom Hash Operator Class 538 Choosing the Table Storage Model 540 Heap Storage 541 Append-Optimized Storage 541 To create a heap table 541 Choosing Row or Column-Oriented Changing the Distribution Policy 550 Redistributing Table Data 551 Altering the Table Storage Model 551 Adding a Compressed Column to Table 551 Inheritance of Compression Settings 552 Dropping a Customer Support 1171 Greenplum Database Best Practices 1172 Best Practices Summary 1173 Data Model 1173 Heap vs. Append-Optimized Storage 1173 Row vs. Column Oriented Storage 1173 Compression 1174

Distribution Key Hash Functions 456 Example Custom Hash Operator Class 456 Choosing the Table Storage Model 458 Heap Storage 458 Append-Optimized Storage 458 VMware Tanzu Greenplum 6 Documentation VMware Changing the Distribution Policy 467 Redistributing Table Data 467 Altering the Table Storage Model 468 Adding a Compressed Column to Table 468 Inheritance of Compression Settings 468 Dropping a Customer Support 1023 Greenplum Database Best Practices 1024 Best Practices Summary 1025 Data Model 1025 Heap vs. Append-Optimized Storage 1025 Row vs. Column Oriented Storage 1025 Compression 1025

Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 538 Append-Optimized Storage 538 To create a heap table 538 Choosing Row or Column-Oriented Changing the Distribution Policy 548 Redistributing Table Data 548 Altering the Table Storage Model 548 Adding a Compressed Column to Table 549 Inheritance of Compression Settings 549 Dropping a Customer Support 1166 Greenplum Database Best Practices 1167 Best Practices Summary 1168 Data Model 1168 Heap vs. Append-Optimized Storage 1168 Row vs. Column Oriented Storage 1168 Compression 1169

Distribution Key Hash Functions 558 Example Custom Hash Operator Class 559 Choosing the Table Storage Model 561 Heap Storage 561 Append-Optimized Storage 561 To create a heap table 562 Choosing Row or Column-Oriented Changing the Distribution Policy 571 Redistributing Table Data 572 Altering the Table Storage Model 572 Adding a Compressed Column to Table 573 Inheritance of Compression Settings 573 Dropping a Customer Support 1210 Greenplum Database Best Practices 1211 Best Practices Summary 1212 Data Model 1212 Heap vs. Append-Optimized Storage 1212 VMware Greenplum 6 Documentation VMware, Inc 53 Row

Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 537 Append-Optimized Storage 538 To create a heap table 538 Choosing Row or Column-Oriented Changing the Distribution Policy 548 Redistributing Table Data 548 Altering the Table Storage Model 549 Adding a Compressed Column to Table 549 Inheritance of Compression Settings 549 Dropping a Customer Support 1195 Greenplum Database Best Practices 1196 Best Practices Summary 1197 Data Model 1197 Heap vs. Append-Optimized Storage 1197 Row vs. Column Oriented Storage 1197 Compression 1198

Distribution Key Hash Functions 564 Example Custom Hash Operator Class 564 Choosing the Table Storage Model 566 Heap Storage 566 Append-Optimized Storage 567 To create a heap table 567 Choosing Row or Column-Oriented Changing the Distribution Policy 577 Redistributing Table Data 577 Altering the Table Storage Model 578 Adding a Compressed Column to Table 578 Inheritance of Compression Settings 578 Dropping a Customer Support 1227 Greenplum Database Best Practices 1228 Best Practices Summary 1229 Data Model 1229 Heap vs. Append-Optimized Storage 1229 Row vs. Column Oriented Storage 1229 Compression 1230

Master 317 Segments 317 Greenplum Database Best Practices 318 Best Practices Summary 319 Data Model 319 Heap vs. Append-Optimized Storage 319 Row vs. Column Oriented Storage 319 VMware Tanzu Greenplum Data Types 332 Use Types Consistently 332 Choose Data Types that Use the Least Space 332 Storage Model 332 Heap Storage or Append-Optimized Storage 333 Row or Column Orientation 333 Compression 334 Distribution Key Hash Functions 725 Example Custom Hash Operator Class 725 Choosing the Table Storage Model 727 Heap Storage 727 Append-Optimized Storage 727 To create a heap table 728 Choosing Row or Column-Oriented

Distribution Key Hash Functions 331 Example Custom Hash Operator Class 331 Choosing the Table Storage Model 333 Heap Storage 333 Append-Optimized Storage 334 To create a heap table 334 Choosing Row or Column-Oriented Altering the Table Access Method 344 Altering the Table Storage Model 345 Inheritance Rules for Altering a Partitioned Table’s Storage Model 345 Adding a Compressed Column to Table 345 Inheritance of Compression Customer Support 1008 Greenplum Database Best Practices 1009 Best Practices Summary 1010 Data Model 1010 Heap vs. Append-Optimized Storage 1010 Row vs. Column Oriented Storage 1010 Compression 1011