Index 385 Indexes on Expressions 386 Examining Index Usage 386 Managing Indexes 387 To rebuild all indexes on a table 387 Dropping an Index 387 About Indexes on Expressions 387 About Partial Indexes VMware by Broadcom 24 Queries that Contain Subqueries 578 Queries that Contain Common Table Expressions 579 DML Operation Enhancements with GPORCA 580 Changed Behavior with GPORCA 581 GPORCA Limitations 586 SQL Value Expressions 586 Column References 587 Positional Parameters 587 Subscripts 587 Field Selection 588 Operator Invocations 588 Function Calls 589 Aggregate Expressions 589 Limitations

Use Bitmap Indexes 763 When Not to Use Bitmap Indexes 763 Creating an Index 763 Indexes on Expressions 764 Examining Index Usage 764 Managing Indexes 765 To rebuild all indexes on a table 765 Dropping Partitioned Tables 863 Queries that Contain Subqueries 864 Queries that Contain Common Table Expressions 865 DML Operation Enhancements with GPORCA 866 Changed Behavior with the GPORCA 866 Changed 873 SQL Value Expressions 873 Column References 874 Positional Parameters 874 Subscripts 875 Field Selection 875 Operator Invocations 876 Function Calls 876 Aggregate Expressions 876 Limitations

Use Bitmap Indexes 772 When Not to Use Bitmap Indexes 772 Creating an Index 772 Indexes on Expressions 773 Examining Index Usage 773 Managing Indexes 774 To rebuild all indexes on a table 774 Dropping Partitioned Tables 872 Queries that Contain Subqueries 873 Queries that Contain Common Table Expressions 874 DML Operation Enhancements with GPORCA 875 Changed Behavior with the GPORCA 875 Changed 882 SQL Value Expressions 882 Column References 883 Positional Parameters 883 Subscripts 884 Field Selection 884 Operator Invocations 885 Function Calls 885 Aggregate Expressions 885 Limitations

Use Bitmap Indexes 761 When Not to Use Bitmap Indexes 761 Creating an Index 762 Indexes on Expressions 762 Examining Index Usage 763 Managing Indexes 763 To rebuild all indexes on a table 763 Dropping Partitioned Tables 864 Queries that Contain Subqueries 865 Queries that Contain Common Table Expressions 866 DML Operation Enhancements with GPORCA 867 Changed Behavior with GPORCA 867 GPORCA Limitations 874 SQL Value Expressions 874 Column References 875 Positional Parameters 875 Subscripts 876 Field Selection 876 Operator Invocations 877 Function Calls 877 Aggregate Expressions 877 Limitations

Use Bitmap Indexes 695 When Not to Use Bitmap Indexes 695 Creating an Index 695 Indexes on Expressions 696 Examining Index Usage 696 Managing Indexes 697 To rebuild all indexes on a table 697 Dropping Partitioned Tables 795 Queries that Contain Subqueries 796 Queries that Contain Common Table Expressions 797 DML Operation Enhancements with GPORCA 798 Changed Behavior with the GPORCA 798 Changed 805 SQL Value Expressions 805 Column References 806 Positional Parameters 806 Subscripts 807 Field Selection 807 Operator Invocations 808 Function Calls 808 Aggregate Expressions 808 Limitations

Use Bitmap Indexes 601 When Not to Use Bitmap Indexes 602 Creating an Index 602 Indexes on Expressions 602 Examining Index Usage 603 Managing Indexes 604 To rebuild all indexes on a table 604 Dropping Partitioned Tables 782 Queries that Contain Subqueries 783 Queries that Contain Common Table Expressions 784 DML Operation Enhancements with GPORCA 785 VMware Greenplum 6 Documentation VMware by Broadcom 793 SQL Value Expressions 793 Column References 794 Positional Parameters 794 Subscripts 794 Field Selection 795 Operator Invocations 795 Function Calls 796 Aggregate Expressions 796 Limitations

Use Bitmap Indexes 595 When Not to Use Bitmap Indexes 596 Creating an Index 596 Indexes on Expressions 596 Examining Index Usage 597 Managing Indexes 598 To rebuild all indexes on a table 598 Dropping Partitioned Tables 774 Queries that Contain Subqueries 775 Queries that Contain Common Table Expressions 776 DML Operation Enhancements with GPORCA 777 Changed Behavior with GPORCA 777 GPORCA Limitations 784 SQL Value Expressions 785 Column References 785 Positional Parameters 786 Subscripts 786 Field Selection 786 Operator Invocations 787 Function Calls 787 Aggregate Expressions 788 Limitations

Use Bitmap Indexes 488 When Not to Use Bitmap Indexes 488 Creating an Index 488 Indexes on Expressions 489 Examining Index Usage 489 Managing Indexes 490 To rebuild all indexes on a table 490 Dropping Partitioned Tables 644 Queries that Contain Subqueries 645 Queries that Contain Common Table Expressions 646 DML Operation Enhancements with GPORCA 646 Changed Behavior with GPORCA 647 GPORCA Limitations 653 SQL Value Expressions 653 Column References 654 Positional Parameters 654 Subscripts 655 Field Selection 655 Operator Invocations 655 Function Calls 656 Aggregate Expressions 656 Limitations

Documentation VMware, Inc 24 When Not to Use Bitmap Indexes 574 Creating an Index 574 Indexes on Expressions 574 Examining Index Usage 575 Managing Indexes 576 To rebuild all indexes on a table 576 Dropping Partitioned Tables 746 Queries that Contain Subqueries 748 Queries that Contain Common Table Expressions 749 DML Operation Enhancements with GPORCA 749 Changed Behavior with GPORCA 750 GPORCA Limitations 757 SQL Value Expressions 757 Column References 758 Positional Parameters 758 Subscripts 758 Field Selection 759 Operator Invocations 759 Function Calls 760 Aggregate Expressions 760 Limitations

Use Bitmap Indexes 571 When Not to Use Bitmap Indexes 571 Creating an Index 571 Indexes on Expressions 572 Examining Index Usage 572 Managing Indexes 573 To rebuild all indexes on a table 573 Dropping Partitioned Tables 746 Queries that Contain Subqueries 747 Queries that Contain Common Table Expressions 748 DML Operation Enhancements with GPORCA 748 VMware Tanzu Greenplum 6 Documentation VMware 756 SQL Value Expressions 756 Column References 757 Positional Parameters 757 Subscripts 758 Field Selection 758 Operator Invocations 759 Function Calls 759 Aggregate Expressions 759 Limitations