361 Encrypting Data in Tables using PGP 363 Encrypting gpfdist Connections 366 Tuning SQL Queries 368 Tuning SQL Queries 0 How to Generate Explain Plans 368 How to Read Explain Plans 369 Optimizing Database 434 Uninstall the Java JAR files and Software Package 435 Writing PL/Java functions 435 SQL Declaration 436 Type Mapping 436 NULL Handling 437 Complex Types 437 Returning Complex Types 438 Language 0 About Greenplum Database PL/pgSQL 452 Greenplum Database SQL Limitations 452 The PL/pgSQL Language 452 Running SQL Commands 454 PL/pgSQL Plan Caching 454 VMware Greenplum v6.18 Documentation

370 Encrypting Data in Tables using PGP 372 Encrypting gpfdist Connections 375 Tuning SQL Queries 377 Tuning SQL Queries 0 How to Generate Explain Plans 377 How to Read Explain Plans 378 Optimizing Database 444 Uninstall the Java JAR files and Software Package 444 Writing PL/Java functions 445 SQL Declaration 445 Type Mapping 445 NULL Handling 446 Complex Types 447 Returning Complex Types 447 Language 0 About Greenplum Database PL/pgSQL 461 Greenplum Database SQL Limitations 462 The PL/pgSQL Language 462 Running SQL Commands 463 PL/pgSQL Plan Caching 463 PL/pgSQL Examples 464 Example:

134 External Tables 134 Database Utilities 134 Additional Supplied Modules and Extensions 134 SQL Commands 135 Database Maintenance 136 System Functions, Catalog Tables and Views 137 Greenplum Query Limitations 582 Unsupported SQL Query Features 582 Performance Regressions 583 Determining the Query Optimizer that is Used 584 Examples 585 Defining Queries 586 SQL Lexicon 586 SQL Value Expressions 586 Database 762 Uninstall the Java JAR files and Software Package 762 Writing PL/Java functions 763 SQL Declaration 763 Type Mapping 763 NULL Handling 764 Complex Types 765 Returning Complex Types 765

Tables using PGP 298 Encrypting gpfdist Connections 301 Tuning SQL Queries 303 VMware Greenplum v6.17 Documentation VMware, Inc. 13 Tuning SQL Queries 0 How to Generate Explain Plans 303 How to Read Explain Database 369 Uninstall the Java JAR files and Software Package 370 Writing PL/Java functions 370 SQL Declaration 371 Type Mapping 371 NULL Handling 372 Complex Types 372 Returning Complex Types 373 Language 0 About Greenplum Database PL/pgSQL 387 Greenplum Database SQL Limitations 387 The PL/pgSQL Language 387 Running SQL Commands 389 PL/pgSQL Plan Caching 389 PL/pgSQL Examples 390 Example:

Documentation VMware by Broadcom 37 Changed Behavior with GPORCA 786 GPORCA Limitations 787 Unsupported SQL Query Features 787 Performance Regressions 788 Determining the Query Optimizer that is Used 788 789 About Uniform Multi-level Partitioned Tables 790 Example 791 Defining Queries 793 SQL Lexicon 793 SQL Value Expressions 793 Column References 794 Positional Parameters 794 Subscripts 794 Field Database 973 Uninstall the Java JAR files and Software Package 973 Writing PL/Java functions 974 SQL Declaration 974 Type Mapping 974 NULL Handling 975 Complex Types 976 Returning Complex Types 976

Enhancements with GPORCA 749 Changed Behavior with GPORCA 750 GPORCA Limitations 751 Unsupported SQL Query Features 751 Performance Regressions 752 Determining the Query Optimizer that is Used 753 754 About Uniform Multi-level Partitioned Tables 754 Example 755 Defining Queries 757 SQL Lexicon 757 SQL Value Expressions 757 Column References 758 Positional Parameters 758 Subscripts 758 Field value of null should not be confused with a SQL NULL. While calling json_typeof('null'::json) will return null, calling json_typeof(NULL::json) will return a SQL NULL. 796 f1 f2 797 1 true [2,false] 798

Enhancements with GPORCA 777 Changed Behavior with GPORCA 777 GPORCA Limitations 778 Unsupported SQL Query Features 779 Performance Regressions 780 Determining the Query Optimizer that is Used 780 781 About Uniform Multi-level Partitioned Tables 782 Example 782 Defining Queries 784 SQL Lexicon 784 SQL Value Expressions 785 Column References 785 Positional Parameters 786 Subscripts 786 Field Database 960 Uninstall the Java JAR files and Software Package 960 Writing PL/Java functions 961 SQL Declaration 961 Type Mapping 962 NULL Handling 962 Complex Types 963 Returning Complex Types 963

PGP Keys 365 Encrypting Data in Tables using PGP 367 Encrypting gpfdist Connections 370 Tuning SQL Queries 372 How to Generate Explain Plans 372 How to Read Explain Plans 373 Optimizing Greenplum Database 439 Uninstall the Java JAR files and Software Package 439 Writing PL/Java functions 439 SQL Declaration 440 Type Mapping 440 NULL Handling 441 Complex Types 441 Returning Complex Types 442 Language 455 About Greenplum Database PL/pgSQL 456 Greenplum Database SQL Limitations 456 The PL/pgSQL Language 456 Running SQL Commands 457 PL/pgSQL Plan Caching 458 PL/pgSQL Examples 458 Example:

Documentation VMware, Inc. 33 Changed Behavior with GPORCA 749 GPORCA Limitations 750 Unsupported SQL Query Features 750 Performance Regressions 752 Determining the Query Optimizer that is Used 752 753 About Uniform Multi-level Partitioned Tables 754 Example 754 Defining Queries 756 SQL Lexicon 756 SQL Value Expressions 756 Column References 757 Positional Parameters 757 Subscripts 758 Field Database 925 Uninstall the Java JAR files and Software Package 925 Writing PL/Java functions 926 SQL Declaration 926 Type Mapping 927 NULL Handling 927 Complex Types 928 Returning Complex Types 928

Enhancements with GPORCA 756 Changed Behavior with GPORCA 757 GPORCA Limitations 758 Unsupported SQL Query Features 758 Performance Regressions 759 Determining the Query Optimizer that is Used 759 35 About Uniform Multi-level Partitioned Tables 761 Example 762 Defining Queries 763 SQL Lexicon 764 SQL Value Expressions 764 Column References 765 Positional Parameters 765 Subscripts 765 Field Database 942 Uninstall the Java JAR files and Software Package 942 Writing PL/Java functions 942 SQL Declaration 943 Type Mapping 943 NULL Handling 944 Complex Types 944 Returning Complex Types 945