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 Bayes Classification 402 References 406 Graph Analytics 406 Graph Analytics 0 What is a Graph? 406 Graph Analytics on Greenplum 407 Using Graph 407 Graph Modules 409 All Pairs Shortest Path (APSP)

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 Bayes Classification 393 References 397 Graph Analytics 397 Graph Analytics 0 What is a Graph? 397 Graph Analytics on Greenplum 398 Using Graph 398 Graph Modules 400 All Pairs Shortest Path (APSP)

Greenplum Database Best Practices 0 Best Practices Summary 248 Best Practices Summary 0 Data Model 248 Heap vs. Append-Optimized Storage 248 Row vs. Column Oriented Storage 248 Compression 249 Data Types 261 Use Types Consistently 261 Choose Data Types that Use the Least Space 261 Storage Model 261 Heap Storage or Append-Optimized Storage 262 Row or Column Orientation 262 Compression 263 Bayes Classification 328 References 332 Graph Analytics 332 Graph Analytics 0 What is a Graph? 332 Graph Analytics on Greenplum 333 Using Graph 333 Graph Modules 335 All Pairs Shortest Path (APSP)

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 Tanzu Greenplum v6.20 Documentation VMware, Inc. 18 Graph Analytics 401 What is a Graph? 401 Graph Analytics on Greenplum 402 Using Graph 403 Graph Modules 404 All Pairs Shortest Path (APSP) 404 Breadth-First

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 875 Naive Bayes Classification 877 References 881 Graph Analytics 881 What is a Graph? 881 Graph Analytics on Greenplum 882 Using Graph 883 Graph Modules 884 All Pairs Shortest Path (APSP) 884 Breadth-First

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 762 Naive Bayes Classification 763 References 767 Graph Analytics 767 What is a Graph? 767 Graph Analytics on Greenplum 768 Using Graph 768 Graph Modules 770 All Pairs Shortest Path (APSP) 770 Breadth-First

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 873 Naive Bayes Classification 875 References 879 Graph Analytics 879 What is a Graph? 880 Graph Analytics on Greenplum 880 Using Graph 881 Graph Modules 882 All Pairs Shortest Path (APSP) 882 Breadth-First

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 Classification 905 References 909 Graph Analytics 909 VMware Greenplum 6 Documentation VMware, Inc 37 What is a Graph? 910 Graph Analytics on Greenplum 910 Using Graph 911 Graph Modules 913 All Pairs Shortest

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 885 Naive Bayes Classification 886 References 891 Graph Analytics 891 What is a Graph? 891 Graph Analytics on Greenplum 892 Using Graph 893 Graph Modules 894 All Pairs Shortest Path (APSP) 894 Breadth-First

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 914 Naive Bayes Classification 916 References 920 Graph Analytics 920 What is a Graph? 920 Graph Analytics on Greenplum 921 Using Graph 922 Graph Modules 923 All Pairs Shortest Path (APSP) 923 Breadth-First