Partitioned Tables 302 Configuring Statistics 303 Statistics Target 303 Automatic Statistics Collection 304 VMware Tanzu Greenplum on vSphere 306 Overview 306 Getting Started 307 VMware Tanzu Greenplum 770 GPORCA and Leaf Partition Statistics 771 Deactivating Automatic Root Partition Statistics Collection 771 Considerations when Using GPORCA 772 GPORCA Features and Enhancements 773 Queries Against Database Statistics 1162 Identifying Statistics Problems in Query Plans 1163 Tuning Statistics Collection 1163 Optimizing Data Distribution 1163 Optimizing Your Database Design 1164 Greenplum Database

Documentation VMware, Inc 12 Configuring Statistics 292 Statistics Target 292 Automatic Statistics Collection 293 VMware Tanzu Greenplum on vSphere 295 Supported Platforms 295 Overview 296 Getting Started 743 GPORCA and Leaf Partition Statistics 744 Deactivating Automatic Root Partition Statistics Collection 744 Considerations when Using GPORCA 744 GPORCA Features and Enhancements 746 VMware Tanzu Greenplum Database Statistics 1126 Identifying Statistics Problems in Query Plans 1127 Tuning Statistics Collection 1127 Optimizing Data Distribution 1127 Optimizing Your Database Design 1127 Greenplum Database

Partitioned Tables 334 Configuring Statistics 335 Statistics Target 335 Automatic Statistics Collection 336 VMware Greenplum on vSphere 338 Overview 338 Getting Started 339 VMware Greenplum on vSphere 778 GPORCA and Leaf Partition Statistics 779 Deactivating Automatic Root Partition Statistics Collection 779 Considerations when Using GPORCA 780 GPORCA Features and Enhancements 782 Queries Against Database Statistics 1177 Identifying Statistics Problems in Query Plans 1178 Tuning Statistics Collection 1178 Optimizing Data Distribution 1179 Optimizing Your Database Design 1179 Greenplum Database

Partitioned Tables 320 Configuring Statistics 321 Statistics Target 321 Automatic Statistics Collection 322 VMware Greenplum on vSphere 324 Overview 324 Getting Started 325 VMware Greenplum on vSphere 749 GPORCA and Leaf Partition Statistics 750 Deactivating Automatic Root Partition Statistics Collection 750 Considerations when Using GPORCA 751 GPORCA Features and Enhancements 752 Queries Against Database Statistics 1145 Identifying Statistics Problems in Query Plans 1146 Tuning Statistics Collection 1146 Optimizing Data Distribution 1147 Optimizing Your Database Design 1147 Greenplum Database

344 Improving Statistics Quality 345 When to Run ANALYZE 345 Configuring Automatic Statistics Collection 345 Managing Bloat in a Database 346 Managing Bloat in a Database 0 About Bloat 346 Detecting 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 Database Statistics 999 Identifying Statistics Problems in Query Plans 1000 Tuning Statistics Collection 1000 Optimizing Data Distribution 1001 Optimizing Your Database Design 1001 Greenplum Database

353 Improving Statistics Quality 354 When to Run ANALYZE 354 Configuring Automatic Statistics Collection 354 Managing Bloat in a Database 355 Managing Bloat in a Database 0 About Bloat 355 Detecting 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 Database Statistics 1008 Identifying Statistics Problems in Query Plans 1009 Tuning Statistics Collection 1009 Optimizing Data Distribution 1010 Optimizing Your Database Design 1010 Greenplum Database

Partitioned Tables 288 Configuring Statistics 288 Statistics Target 288 Automatic Statistics Collection 289 VMware Tanzu Greenplum on vSphere 291 Overview 291 Getting Started 292 VMware Tanzu Greenplum 742 GPORCA and Leaf Partition Statistics 743 Deactivating Automatic Root Partition Statistics Collection 743 Considerations when Using GPORCA 743 GPORCA Features and Enhancements 745 Queries Against Database Statistics 1121 Identifying Statistics Problems in Query Plans 1122 Tuning Statistics Collection 1122 Optimizing Data Distribution 1122 Optimizing Your Database Design 1123 Greenplum Database

Partitioned Tables 261 Configuring Statistics 261 Statistics Target 261 Automatic Statistics Collection 262 VMware Tanzu Greenplum on vSphere 264 Supported Platforms 264 Overview 265 Getting Started ANALYZE 640 GPORCA and Leaf Partition Statistics 641 Disabling Automatic Root Partition Statistics Collection 641 Considerations when Using GPORCA 642 GPORCA Features and Enhancements 643 Queries Against Database Statistics 983 Identifying Statistics Problems in Query Plans 983 Tuning Statistics Collection 983 Optimizing Data Distribution 984 Optimizing Your Database Design 984 Greenplum Database

279 Improving Statistics Quality 280 When to Run ANALYZE 280 Configuring Automatic Statistics Collection 280 Managing Bloat in a Database 281 VMware Greenplum v6.17 Documentation VMware, Inc. 12 Managing ANALYZE 791 GPORCA and Leaf Partition Statistics 792 Disabling Automatic Root Partition Statistics Collection 792 Considerations when Using GPORCA 793 Considerations when Using GPORCA 0 GPORCA Features Database Statistics 934 Identifying Statistics Problems in Query Plans 934 Tuning Statistics Collection 934 Optimizing Data Distribution 935 Optimizing Your Database Design 935 Greenplum Database

348 Improving Statistics Quality 349 When to Run ANALYZE 349 Configuring Automatic Statistics Collection 349 Managing Bloat in a Database 350 About Bloat 350 Detecting Bloat 351 Removing Bloat from Tanzu Greenplum v6.20 Documentation VMware, Inc. 44 Disabling Automatic Root Partition Statistics Collection 861 Considerations when Using GPORCA 862 GPORCA Features and Enhancements 863 Queries Against Database Statistics 999 Identifying Statistics Problems in Query Plans 1000 Tuning Statistics Collection 1000 Optimizing Data Distribution 1000 Optimizing Your Database Design 1001 Greenplum Database