Features and Enhancements 577 Queries Against Partitioned Tables 577 VMware Greenplum 7 Documentation VMware by Broadcom 24 Queries that Contain Subqueries 578 Queries that Contain Common Table Expressions Performance Regressions 583 Determining the Query Optimizer that is Used 584 Examples 585 Defining Queries 586 SQL Lexicon 586 SQL Value Expressions 586 Column References 587 Positional Parameters 587 Broadcom 25 Array Constructors 599 Row Constructors 600 Expression Evaluation Rules 601 WITH Queries (Common Table Expressions) 602 SELECT in a WITH Clause 602 Data-Modifying Statements in a WITH

when Using GPORCA 780 GPORCA Features and Enhancements 782 Queries Against Partitioned Tables 782 Queries that Contain Subqueries 783 Queries that Contain Common Table Expressions 784 DML Operation Enhancements Used 788 Examples 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 VMware Greenplum 6 Documentation VMware by Broadcom 38 Expression Evaluation Rules 806 WITH Queries (Common Table Expressions) 807 SELECT in a WITH Clause 807 Data-Modifying Statements in a WITH

when Using GPORCA 751 GPORCA Features and Enhancements 752 Queries Against Partitioned Tables 753 Queries that Contain Subqueries 754 Queries that Contain Common Table Expressions 755 DML Operation Enhancements Documentation VMware, Inc. 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 Clauses 774 Array Constructors 775 Row Constructors 776 Expression Evaluation Rules 777 WITH Queries (Common Table Expressions) 778 SELECT in a WITH Clause 778 Data-Modifying Statements in a WITH

when Using GPORCA 772 GPORCA Features and Enhancements 773 Queries Against Partitioned Tables 774 Queries that Contain Subqueries 775 Queries that Contain Common Table Expressions 776 DML Operation Enhancements VMware, Inc 33 Examples 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 Clauses 795 Array Constructors 795 Row Constructors 796 Expression Evaluation Rules 797 WITH Queries (Common Table Expressions) 798 SELECT in a WITH Clause 799 Data-Modifying Statements in a WITH

746 VMware Tanzu Greenplum 6 Documentation VMware, Inc 32 Queries Against Partitioned Tables 746 Queries that Contain Subqueries 748 Queries that Contain Common Table Expressions 749 DML Operation Enhancements Used 753 Examples 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 Clauses 767 Array Constructors 768 Row Constructors 769 Expression Evaluation Rules 770 WITH Queries (Common Table Expressions) 770 SELECT in a WITH Clause 771 Data-Modifying Statements in a WITH

when Using GPORCA 743 GPORCA Features and Enhancements 745 Queries Against Partitioned Tables 746 Queries that Contain Subqueries 747 Queries that Contain Common Table Expressions 748 DML Operation Enhancements Used 752 Examples 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 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 34 Expression Evaluation Rules 769 WITH Queries (Common Table Expressions) 770 SELECT in a WITH Clause 770 Data-Modifying Statements in a WITH

when Using GPORCA 642 GPORCA Features and Enhancements 643 Queries Against Partitioned Tables 644 Queries that Contain Subqueries 645 Queries that Contain Common Table Expressions 646 DML Operation Enhancements Used 650 Examples 650 About Uniform Multi-level Partitioned Tables 651 Example 651 Defining Queries 653 SQL Lexicon 653 SQL Value Expressions 653 Column References 654 Positional Parameters 654 Clauses 663 Array Constructors 663 Row Constructors 664 Expression Evaluation Rules 665 WITH Queries (Common Table Expressions) 666 SELECT in a WITH Clause 666 Data-Modifying Statements in a WITH

针对业务关键分析功能提供企业级集 成、支持和发布 • 为新一代分析处理技术开启了大门– 其中包括文本分析、图形分析、数据 挖掘、机器学习以及更多内容 客户实例：福克斯互动媒体 （Fox Interactive Media） • 业务问题 • 改进定位广告 • 竞争对手 • Teradata, Oracle • 数据规模 • 1万亿行事实数据表，每天增加 3TB • 硬件 • 40节点的Sun数据仓库设备 web-based performance monitoring Real-time and historic views of: •Resource utilization •Queries and query internals Dashboard Greenplum Performance Monitor

Memory Considerations when using Resource Groups 345 Configuring Resource Groups 346 Low Memory Queries 346 Administrative Utilities and admin_group Concurrency 347 Memory and Resource Management with Resolving Out of Memory Errors 347 VMware Greenplum v6.19 Documentation VMware, Inc. 16 Low Memory Queries 348 Configuring Memory for Greenplum Database 348 Configuring Resource Queues 350 System Monitoring gpfdist Connections 375 Tuning SQL Queries 377 Tuning SQL Queries 0 How to Generate Explain Plans 377 How to Read Explain Plans 378 Optimizing Greenplum Queries 380 Greenplum Grouping Extensions 381

Memory Considerations when using Resource Groups 336 Configuring Resource Groups 337 Low Memory Queries 337 Administrative Utilities and admin_group Concurrency 338 VMware Greenplum v6.18 Documentation Memory and Resource Management with Resource Queues 0 Resolving Out of Memory Errors 338 Low Memory Queries 339 Configuring Memory for Greenplum Database 339 Configuring Resource Queues 341 System Monitoring gpfdist Connections 366 Tuning SQL Queries 368 Tuning SQL Queries 0 How to Generate Explain Plans 368 How to Read Explain Plans 369 Optimizing Greenplum Queries 371 Greenplum Grouping Extensions 372