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 Planning and Dispatch 736 Understanding Greenplum Query Plans 737 Understanding Parallel Query Execution 739 About GPORCA 740 Overview of GPORCA 741 Activating and Deactivating GPORCA 741 Enabling

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 Planning and Dispatch 634 Understanding Greenplum Query Plans 635 Understanding Parallel Query Execution 637 About GPORCA 638 Overview of GPORCA 639 Enabling and Disabling GPORCA 639 Enabling GPORCA

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 Planning and Dispatch 772 Understanding Greenplum Query Plans 773 Understanding Parallel Query Execution 774 About GPORCA 775 Overview of GPORCA 776 Activating and Deactivating GPORCA 777 Enabling

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 Planning and Dispatch 735 Understanding Greenplum Query Plans 736 Understanding Parallel Query Execution 738 About GPORCA 739 Overview of GPORCA 740 Activating and Deactivating GPORCA 740 Enabling

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 Planning and Dispatch 742 Understanding Greenplum Query Plans 744 Understanding Parallel Query Execution 745 About GPORCA 746 Overview of GPORCA 747 Activating and Deactivating GPORCA 748 Enabling

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 Planning and Dispatch 763 Understanding Greenplum Query Plans 764 Understanding Parallel Query Execution 766 About GPORCA 767 Overview of GPORCA 768 Activating and Deactivating GPORCA 768 Enabling

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 Planning and Dispatch 566 Understanding Greenplum Query Plans 568 Understanding Parallel Query Execution 569 About GPORCA 570 Overview of GPORCA 571 Activating and Deactivating GPORCA 572 Enabling