Additional Information 353 Updating Statistics with ANALYZE 353 Updating Statistics with ANALYZE 0 Generating Statistics Selectively 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 Bloat 356 Removing Bloat from Database Tables 357 Removing Segments 609 To run gpexpand with an input file 609 Monitoring the Cluster Expansion State 609 Rolling Back a Failed Expansion Setup 609 VMware Greenplum v6.19 Documentation VMware, Inc. 35 Redistributing

Additional Information 344 Updating Statistics with ANALYZE 344 Updating Statistics with ANALYZE 0 Generating Statistics Selectively 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 Bloat 347 Removing Bloat from Database Tables 348 Removing Segments 600 To run gpexpand with an input file 600 Monitoring the Cluster Expansion State 600 Rolling Back a Failed Expansion Setup 600 VMware Greenplum v6.18 Documentation VMware, Inc. 34 Redistributing

Information 348 Updating Statistics with ANALYZE 348 Generating Statistics Selectively 348 Improving Statistics Quality 349 When to Run ANALYZE 349 Configuring Automatic Statistics Collection 349 Managing Segments 599 To run gpexpand with an input file 599 Monitoring the Cluster Expansion State 600 Rolling Back a Failed Expansion Setup 600 Redistributing Tables 600 Ranking Tables for Redistribution 601 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 Statistics Collection

329 About Database Statistics in Greenplum Database 329 System Statistics 330 Table Size 330 The pg_statistic System Table and pg_stats View 330 Sampling 334 Updating Statistics 334 Analyzing Partitioned 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 Query 778 Collecting Root Partition Statistics 778 Running ANALYZE 778 GPORCA and Leaf Partition Statistics 779 Deactivating Automatic Root Partition Statistics Collection 779 Considerations when Using

Additional Information 279 Updating Statistics with ANALYZE 279 Updating Statistics with ANALYZE 0 Generating Statistics Selectively 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 Bloat in a Database 0 About Bloat 281 Detecting Bloat Segments 532 To run gpexpand with an input file 532 Monitoring the Cluster Expansion State 532 Rolling Back a Failed Expansion Setup 532 Redistributing Tables 533 VMware Greenplum v6.17 Documentation

297 About Database Statistics in Greenplum Database 297 System Statistics 298 Table Size 298 The pg_statistic System Table and pg_stats View 298 Sampling 302 Updating Statistics 302 Analyzing Partitioned 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 Query 769 Collecting Root Partition Statistics 770 Running ANALYZE 770 GPORCA and Leaf Partition Statistics 771 Deactivating Automatic Root Partition Statistics Collection 771 Considerations when Using

315 About Database Statistics in Greenplum Database 315 System Statistics 316 Table Size 316 The pg_statistic System Table and pg_stats View 316 Sampling 320 Updating Statistics 320 Analyzing Partitioned 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 Query 749 Collecting Root Partition Statistics 749 Running ANALYZE 749 GPORCA and Leaf Partition Statistics 750 Deactivating Automatic Root Partition Statistics Collection 750 Considerations when Using

286 About Database Statistics in Greenplum Database 286 System Statistics 287 Table Size 287 The pg_statistic System Table and pg_stats View 287 Sampling 291 Updating Statistics 291 Analyzing Partitioned 292 VMware Tanzu Greenplum 6 Documentation VMware, Inc 12 Configuring Statistics 292 Statistics Target 292 Automatic Statistics Collection 293 VMware Tanzu Greenplum on vSphere 295 Supported Platforms Query 742 Collecting Root Partition Statistics 742 Running ANALYZE 743 GPORCA and Leaf Partition Statistics 744 Deactivating Automatic Root Partition Statistics Collection 744 Considerations when Using

256 About Database Statistics in Greenplum Database 256 System Statistics 257 Table Size 257 The pg_statistic System Table and pg_stats View 257 Sampling 260 Updating Statistics 260 Analyzing Partitioned 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 a Query 640 Collecting Root Partition Statistics 640 Running ANALYZE 640 GPORCA and Leaf Partition Statistics 641 Disabling Automatic Root Partition Statistics Collection 641 Considerations when Using

282 About Database Statistics in Greenplum Database 283 System Statistics 283 Table Size 283 The pg_statistic System Table and pg_stats View 284 Sampling 287 Updating Statistics 287 Analyzing Partitioned 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 Query 741 Collecting Root Partition Statistics 742 Running ANALYZE 742 GPORCA and Leaf Partition Statistics 743 Deactivating Automatic Root Partition Statistics Collection 743 Considerations when Using