Summary 324 Best Practices Summary 0 Data Model 324 Heap vs. Append-Optimized Storage 324 Row vs. Column Oriented Storage 324 Compression 325 Distributions 325 Resource Queue Memory Management 325 Partitioning Use the Least Space 337 Storage Model 337 Heap Storage or Append-Optimized Storage 338 Row or Column Orientation 338 Compression 339 Distributions 339 Local (Co-located) Joins 340 Data Skew 340 Processing Skew 341 Partitioning 341 Number of Partition and Columnar Storage Files 342 Indexes 343 Column Sequence and Byte Alignment 344 Memory and Resource Management with Resource Groups 344 Memory

Summary 315 Best Practices Summary 0 Data Model 315 Heap vs. Append-Optimized Storage 315 Row vs. Column Oriented Storage 315 Compression 316 Distributions 316 Resource Queue Memory Management 316 Partitioning Use the Least Space 328 Storage Model 328 Heap Storage or Append-Optimized Storage 329 Row or Column Orientation 329 Compression 330 Distributions 330 Local (Co-located) Joins 331 Data Skew 331 Processing Skew 332 Partitioning 332 Number of Partition and Columnar Storage Files 333 Indexes 334 Column Sequence and Byte Alignment 335 Memory and Resource Management with Resource Groups 335 Memory

Summary 248 Best Practices Summary 0 Data Model 248 Heap vs. Append-Optimized Storage 248 Row vs. Column Oriented Storage 248 Compression 249 Distributions 249 Resource Queue Memory Management 249 VMware Use the Least Space 261 Storage Model 261 Heap Storage or Append-Optimized Storage 262 Row or Column Orientation 262 Compression 263 Distributions 263 Local (Co-located) Joins 264 Data Skew 264 VMware, Inc. 11 Partitioning 267 Number of Partition and Columnar Storage Files 268 Indexes 269 Column Sequence and Byte Alignment 270 Memory and Resource Management with Resource Groups 270 Memory

Practices 318 Best Practices Summary 319 Data Model 319 Heap vs. Append-Optimized Storage 319 Row vs. Column Oriented Storage 319 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 14 Compression 320 Use the Least Space 332 Storage Model 332 Heap Storage or Append-Optimized Storage 333 Row or Column Orientation 333 Compression 334 Distributions 334 Local (Co-located) Joins 335 Data Skew 335 VMware, Inc. 15 Partitioning 336 Number of Partition and Columnar Storage Files 337 Indexes 338 Column Sequence and Byte Alignment 339 Memory and Resource Management with Resource Groups 339 Configuring

Schemas 554 Creating and Managing Tables 554 Creating a Table 554 Choosing Column Data Types 555 Setting Table and Column Constraints 555 Check Constraints 556 Not-Null Constraints 556 Unique Constraints 561 Append-Optimized Storage 561 To create a heap table 562 Choosing Row or Column-Oriented Storage 562 To create a column-oriented table 563 VMware Greenplum 6 Documentation VMware, Inc 23 Using Compression for Run-length Encoding 566 Adding Column-level Compression 566 Default Compression Values 568 Precedence of Compression Settings 568 Optimal Location for Column Compression Settings 568 Storage Directives

Schemas 534 Creating and Managing Tables 534 Creating a Table 534 Choosing Column Data Types 534 Setting Table and Column Constraints 535 Check Constraints 535 Not-Null Constraints 536 Unique Constraints 541 Append-Optimized Storage 541 To create a heap table 541 Choosing Row or Column-Oriented Storage 541 To create a column-oriented table 542 Using Compression (Append-Optimized Tables Only) 543 To for Run-length Encoding 545 Adding Column-level Compression 545 Default Compression Values 547 Precedence of Compression Settings 547 Optimal Location for Column Compression Settings 547 Storage Directives

Schemas 559 Creating and Managing Tables 559 Creating a Table 560 Choosing Column Data Types 560 Setting Table and Column Constraints 560 Check Constraints 561 Not-Null Constraints 561 Unique Constraints 566 Append-Optimized Storage 567 To create a heap table 567 Choosing Row or Column-Oriented Storage 567 To create a column-oriented table 568 Using Compression (Append-Optimized Tables Only) 569 To Documentation VMware by Broadcom 27 Adding Column-level Compression 572 Default Compression Values 573 Precedence of Compression Settings 573 Optimal Location for Column Compression Settings 574 Storage Directives

Schemas 530 Creating and Managing Tables 530 Creating a Table 531 Choosing Column Data Types 531 Setting Table and Column Constraints 531 Check Constraints 532 Not-Null Constraints 532 Unique Constraints 537 Append-Optimized Storage 538 To create a heap table 538 Choosing Row or Column-Oriented Storage 538 To create a column-oriented table 539 Using Compression (Append-Optimized Tables Only) 540 To for Run-length Encoding 542 Adding Column-level Compression 543 Default Compression Values 544 Precedence of Compression Settings 544 Optimal Location for Column Compression Settings 545 Storage Directives

Schemas 531 Creating and Managing Tables 531 Creating a Table 531 Choosing Column Data Types 532 Setting Table and Column Constraints 532 Check Constraints 532 Not-Null Constraints 533 Unique Constraints 538 Append-Optimized Storage 538 To create a heap table 538 Choosing Row or Column-Oriented Storage 539 To create a column-oriented table 540 Using Compression (Append-Optimized Tables Only) 540 To Adding Column-level Compression 542 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 23 Default Compression Values 544 Precedence of Compression Settings 544 Optimal Location for Column Compression

Schemas 452 Creating and Managing Tables 452 Creating a Table 452 Choosing Column Data Types 453 Setting Table and Column Constraints 453 Check Constraints 453 Not-Null Constraints 454 Unique Constraints 6 Documentation VMware, Inc 21 To create a heap table 459 Choosing Row or Column-Oriented Storage 459 To create a column-oriented table 460 Using Compression (Append-Optimized Tables Only) 460 To for Run-length Encoding 462 Adding Column-level Compression 462 Default Compression Values 464 Precedence of Compression Settings 464 Optimal Location for Column Compression Settings 464 Storage Directives