How to Read Explain Plans 378 Optimizing Greenplum Queries 380 Greenplum Grouping Extensions 381 Window Functions 381 High Availability 382 High Availability 0 Disk Storage 382 Best Practices 383 Limitations of Aggregate Expressions 886 Window Expressions 887 Window Examples 888 Example 1 – Aggregate Window Function Over a Partition 888 Example 2 – Ranking Window Function With an ORDER BY Clause 889 889 Example 3 – Aggregate Function over a Row Window Frame 890 Example 4 – Aggregate Function for a Range Window Frame 890 Type Casts 891 Scalar Subqueries 891 Correlated Subqueries 892 Correlated

How to Read Explain Plans 369 Optimizing Greenplum Queries 371 Greenplum Grouping Extensions 372 Window Functions 373 High Availability 373 High Availability 0 Disk Storage 373 Best Practices 374 Limitations of Aggregate Expressions 877 Window Expressions 878 Window Examples 879 Example 1 – Aggregate Window Function Over a Partition 879 Example 2 – Ranking Window Function With an ORDER BY Clause 880 880 Example 3 – Aggregate Function over a Row Window Frame 881 Example 4 – Aggregate Function for a Range Window Frame 881 Type Casts 882 Scalar Subqueries 882 Correlated Subqueries 883 Correlated

How to Read Explain Plans 373 Optimizing Greenplum Queries 375 Greenplum Grouping Extensions 376 Window Functions 376 High Availability 377 Disk Storage 377 Best Practices 377 Master Mirroring 378 Limitations of Aggregate Expressions 878 Window Expressions 879 Window Examples 881 Example 1 – Aggregate Window Function Over a Partition 881 Example 2 – Ranking Window Function With an ORDER BY Clause 881 881 Example 3 – Aggregate Function over a Row Window Frame 882 Example 4 – Aggregate Function for a Range Window Frame 882 Type Casts 883 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 45

How to Read Explain Plans 304 Optimizing Greenplum Queries 306 Greenplum Grouping Extensions 307 Window Functions 308 High Availability 308 High Availability 0 Disk Storage 308 Best Practices 309 Limitations of Aggregate Expressions 809 Window Expressions 810 Window Examples 811 Example 1 – Aggregate Window Function Over a Partition 811 Example 2 – Ranking Window Function With an ORDER BY Clause 812 812 Example 3 – Aggregate Function over a Row Window Frame 813 Example 4 – Aggregate Function for a Range Window Frame 813 Type Casts 814 Scalar Subqueries 814 Correlated Subqueries 815 Correlated

Limitations of Aggregate Expressions 590 Window Expressions 590 Window Examples 593 Example 1 – Aggregate Window Function Over a Partition 594 Example 2 – Ranking Window Function With an ORDER BY Clause 594 Aggregate Function over a Row Window Frame 595 Example 4 – Aggregate Function for a Range or Groups Window Frame 595 Example 5 – Aggregate Function for a Range and a Groups Window Frame 596 Type Casts 597 611 User-Defined Functions 611 User-Defined Procedures 612 Built-in Functions and Operators 612 Window Functions 617 Advanced Aggregate Functions 619 Working with JSON Data 620 About JSON Data 620

Limitations of Aggregate Expressions 797 Window Expressions 797 Window Examples 799 Example 1 – Aggregate Window Function Over a Partition 799 Example 2 – Ranking Window Function With an ORDER BY Clause 800 800 Example 3 – Aggregate Function over a Row Window Frame 800 Example 4 – Aggregate Function for a Range Window Frame 801 Type Casts 801 Scalar Subqueries 802 Correlated Subqueries 802 Correlated Volatility and Plan Caching 814 User-Defined Functions 814 Built-in Functions and Operators 815 Window Functions 820 Advanced Aggregate Functions 821 Working with JSON Data 822 About JSON Data 823

Limitations of Aggregate Expressions 788 Window Expressions 789 Window Examples 791 Example 1 – Aggregate Window Function Over a Partition 791 Example 2 – Ranking Window Function With an ORDER BY Clause 791 791 Example 3 – Aggregate Function over a Row Window Frame 792 Example 4 – Aggregate Function for a Range Window Frame 792 Type Casts 793 Scalar Subqueries 794 Correlated Subqueries 794 Correlated Volatility and Plan Caching 805 User-Defined Functions 806 Built-in Functions and Operators 806 Window Functions 810 Advanced Aggregate Functions 812 Working with JSON Data 813 About JSON Data 814

Limitations of Aggregate Expressions 657 Window Expressions 657 Window Examples 659 Example 1 – Aggregate Window Function Over a Partition 659 Example 2 – Ranking Window Function With an ORDER BY Clause 660 660 Example 3 – Aggregate Function over a Row Window Frame 660 Example 4 – Aggregate Function for a Range Window Frame 660 Type Casts 661 Scalar Subqueries 662 Correlated Subqueries 662 Correlated Volatility and Plan Caching 672 User-Defined Functions 672 Built-in Functions and Operators 673 Window Functions 676 Advanced Aggregate Functions 677 Table 5. Advanced Aggregate Functions Function Return

Limitations of Aggregate Expressions 761 Window Expressions 761 Window Examples 763 Example 1 – Aggregate Window Function Over a Partition 763 Example 2 – Ranking Window Function With an ORDER BY Clause 764 764 Example 3 – Aggregate Function over a Row Window Frame 764 Example 4 – Aggregate Function for a Range Window Frame 765 Type Casts 765 Scalar Subqueries 766 Correlated Subqueries 766 Correlated Volatility and Plan Caching 777 User-Defined Functions 778 Built-in Functions and Operators 778 Window Functions 782 Advanced Aggregate Functions 784 Table 5. Advanced Aggregate Functions Function Return

Limitations of Aggregate Expressions 768 Window Expressions 768 Window Examples 770 Example 1 – Aggregate Window Function Over a Partition 770 Example 2 – Ranking Window Function With an ORDER BY Clause 771 771 Example 3 – Aggregate Function over a Row Window Frame 771 Example 4 – Aggregate Function for a Range Window Frame 772 Type Casts 772 Scalar Subqueries 773 Correlated Subqueries 773 Correlated Volatility and Plan Caching 785 User-Defined Functions 785 Built-in Functions and Operators 786 Window Functions 791 Advanced Aggregate Functions 792 Working with JSON Data 793 About JSON Data 794