Execution 774 About GPORCA 775 Overview of GPORCA 776 Activating and Deactivating GPORCA 777 Enabling GPORCA for a System 777 Enabling GPORCA for a Database 777 Enabling GPORCA for a Session or a Query 778 Running ANALYZE 778 GPORCA and Leaf Partition Statistics 779 Deactivating Automatic Root Partition Statistics Collection 779 Considerations when Using GPORCA 780 GPORCA Features and Enhancements Expressions 784 DML Operation Enhancements with GPORCA 785 VMware Greenplum 6 Documentation VMware by Broadcom 37 Changed Behavior with GPORCA 786 GPORCA Limitations 787 Unsupported SQL Query Features

Execution 745 About GPORCA 746 Overview of GPORCA 747 Activating and Deactivating GPORCA 748 Enabling GPORCA for a System 748 Enabling GPORCA for a Database 748 Enabling GPORCA for a Session or a Query 749 Running ANALYZE 749 GPORCA and Leaf Partition Statistics 750 Deactivating Automatic Root Partition Statistics Collection 750 Considerations when Using GPORCA 751 GPORCA Features and Enhancements that Contain Common Table Expressions 755 DML Operation Enhancements with GPORCA 756 Changed Behavior with GPORCA 757 GPORCA Limitations 758 Unsupported SQL Query Features 758 Performance Regressions

About GPORCA 865 VMware Greenplum v6.19 Documentation VMware, Inc. 52 About GPORCA 0 Overview of GPORCA 866 Overview of GPORCA 0 Enabling and Disabling GPORCA 866 Enabling and Disabling GPORCA 0 Enabling Enabling GPORCA for a System 867 Enabling GPORCA for a Database 867 Enabling GPORCA for a Session or a Query 867 Collecting Root Partition Statistics 868 Collecting Root Partition Statistics 0 Running ANALYZE 868 GPORCA and Leaf Partition Statistics 869 Disabling Automatic Root Partition Statistics Collection 869 Considerations when Using GPORCA 870 Considerations when Using GPORCA 0 GPORCA Features

Execution 766 About GPORCA 767 Overview of GPORCA 768 Activating and Deactivating GPORCA 768 Enabling GPORCA for a System 769 Enabling GPORCA for a Database 769 Enabling GPORCA for a Session or a Query 770 Running ANALYZE 770 GPORCA and Leaf Partition Statistics 771 Deactivating Automatic Root Partition Statistics Collection 771 Considerations when Using GPORCA 772 GPORCA Features and Enhancements that Contain Common Table Expressions 776 DML Operation Enhancements with GPORCA 777 Changed Behavior with GPORCA 777 GPORCA Limitations 778 Unsupported SQL Query Features 779 Performance Regressions

Query Execution 856 About GPORCA 857 Overview of GPORCA 858 Enabling and Disabling GPORCA 858 Enabling GPORCA for a System 859 Enabling GPORCA for a Database 859 Enabling GPORCA for a Session or a Query Query 859 Collecting Root Partition Statistics 860 Running ANALYZE 860 GPORCA and Leaf Partition Statistics 861 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 44 Disabling Automatic Root Partition Partition Statistics Collection 861 Considerations when Using GPORCA 862 GPORCA Features and Enhancements 863 Queries Against Partitioned Tables 864 Queries that Contain Subqueries 865 Queries that

About GPORCA 856 About GPORCA 0 VMware Greenplum v6.18 Documentation VMware, Inc. 51 Overview of GPORCA 857 Overview of GPORCA 0 Enabling and Disabling GPORCA 857 Enabling and Disabling GPORCA 0 Enabling Enabling GPORCA for a System 858 Enabling GPORCA for a Database 858 Enabling GPORCA for a Session or a Query 858 Collecting Root Partition Statistics 859 Collecting Root Partition Statistics 0 Running ANALYZE 859 GPORCA and Leaf Partition Statistics 860 Disabling Automatic Root Partition Statistics Collection 860 Considerations when Using GPORCA 861 Considerations when Using GPORCA 0 GPORCA Features

Execution 739 About GPORCA 740 Overview of GPORCA 741 Activating and Deactivating GPORCA 741 Enabling GPORCA for a System 742 Enabling GPORCA for a Database 742 Enabling GPORCA for a Session or a Query 742 Running ANALYZE 743 GPORCA and Leaf Partition Statistics 744 Deactivating Automatic Root Partition Statistics Collection 744 Considerations when Using GPORCA 744 GPORCA Features and Enhancements that Contain Common Table Expressions 749 DML Operation Enhancements with GPORCA 749 Changed Behavior with GPORCA 750 GPORCA Limitations 751 Unsupported SQL Query Features 751 Performance Regressions

Execution 738 About GPORCA 739 Overview of GPORCA 740 Activating and Deactivating GPORCA 740 Enabling GPORCA for a System 741 Enabling GPORCA for a Database 741 Enabling GPORCA for a Session or a Query 742 Running ANALYZE 742 GPORCA and Leaf Partition Statistics 743 Deactivating Automatic Root Partition Statistics Collection 743 Considerations when Using GPORCA 743 GPORCA Features and Enhancements Expressions 748 DML Operation Enhancements with GPORCA 748 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 33 Changed Behavior with GPORCA 749 GPORCA Limitations 750 Unsupported SQL Query Features

Query Execution 637 About GPORCA 638 Overview of GPORCA 639 Enabling and Disabling GPORCA 639 Enabling GPORCA for a System 640 Enabling GPORCA for a Database 640 Enabling GPORCA for a Session or a Query 640 Running ANALYZE 640 GPORCA and Leaf Partition Statistics 641 Disabling Automatic Root Partition Statistics Collection 641 Considerations when Using GPORCA 642 GPORCA Features and Enhancements that Contain Common Table Expressions 646 DML Operation Enhancements with GPORCA 646 Changed Behavior with GPORCA 647 GPORCA Limitations 648 Unsupported SQL Query Features 648 Performance Regressions

..............................................................................................6 GPORCA：Pivotal 查询优化器更新 ................................................................................ 有云和私有云）中，也适用不同的本地配置。其大规模并行处理 (MPP) SQL 的设计核心是一个称为 GPORCA 的新一代查 询优化器。GPORCA 专为满足在多结构数据环境中进行高级分析的需求而设计，能够处理多种并发混合工作负载的复杂查 询。与旧式 MPP 数据库中常用的传统 RDBMS 查询优化器相比，GPORCA 大幅度地提高了查询性能。 Pivotal Greenplum 5：新一代数据平台 作为重要的新版本，Pivotal ML/统计数据/图形 程序化 文本 地理空间 公有云 私有云 完全 托管云 本地 BI / 报告 自定义应用 机器学习 AI SQL 大规模 并行处理 (MPP) PB 级数据 加载 查询 优化器 (GPORCA) Workload Manager 多态存储 Command Center SQL 兼容性 (Hyper-Q) PostgreSQL 内核 JSON、Apache AVRO、Apache