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 Tables 334 Configuring Statistics with View Dependencies 605 Finding View Dependencies 606 Finding Direct View Dependencies on a Table 606 Finding Direct Dependencies on a Table Column 607 Listing View Schemas 608 Listing View Definitions Definitions 609 Listing Nested Views 609 Example Data 610 About View Storage in Greenplum Database 611 Where View Dependency Information is Stored 612 Creating and Managing Materialized Views 612 Creating

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 Tables 302 Configuring Statistics with View Dependencies 599 Finding View Dependencies 600 Finding Direct View Dependencies on a Table 600 Finding Direct Dependencies on a Table Column 601 Listing View Schemas 602 Listing View Definitions Definitions 603 Listing Nested Views 603 Example Data 604 About View Storage in Greenplum Database 605 Where View Dependency Information is Stored 606 Creating and Managing Materialized Views 606 Creating

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 Tables 320 Configuring Statistics with View Dependencies 576 Finding View Dependencies 577 Finding Direct View Dependencies on a Table 577 Finding Direct Dependencies on a Table Column 578 Listing View Schemas 579 Listing View Definitions VMware Greenplum 6 Documentation VMware, Inc. 27 Example Data 581 About View Storage in Greenplum Database 582 Where View Dependency Information is Stored 582 Creating and Managing Materialized Views

Greenplum Database 180 System Statistics 181 Table Size 181 The pg_statistic System Table and pg_stats View 181 Sampling 185 Updating Statistics 185 Analyzing Partitioned Tables 185 Configuring Statistics partitionendinclusive 252 partitionboundary 252 Composing a Similar View in Greenplum 7 252 pg_partition_columns 253 Composing a Similar View in Greenplum 7 254 pg_partition_rule 254 pg_partition 255 p pg_partition_templates 256 pg_partition_encoding 257 Composing a Similar View in Greenplum 7 258 pg_stat_partition_operations 258 Migrating from Open Source Greenplum Database to VMware Greenplum 259

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 Tables 292 VMware Tanzu Greenplum with View Dependencies 577 Finding View Dependencies 578 Finding Direct View Dependencies on a Table 578 Finding Direct Dependencies on a Table Column 579 Listing View Schemas 580 Listing View Definitions Definitions 581 Listing Nested Views 581 Example Data 582 About View Storage in Greenplum Database 583 Where View Dependency Information is Stored 584 Creating and Managing Materialized Views 584 Creating

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 Tables 288 Configuring Statistics with View Dependencies 575 Finding View Dependencies 575 Finding Direct View Dependencies on a Table 576 Finding Direct Dependencies on a Table Column 577 Listing View Schemas 577 Listing View Definitions Definitions 578 Listing Nested Views 579 Example Data 579 About View Storage in Greenplum Database 580 Where View Dependency Information is Stored 581 Creating and Managing Materialized Views 581 Creating

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 Tables 261 Configuring Statistics with View Dependencies 491 Finding View Dependencies 492 Finding Direct View Dependencies on a Table 492 Finding Direct Dependencies on a Table Column 493 Listing View Schemas 494 Listing View Definitions Definitions 494 Listing Nested Views 495 Example Data 496 About View Storage in Greenplum Database 497 Where View Dependency Information is Stored 497 Creating and Managing Materialized Views 497 Creating

Memory Usage Information 619 Creating the session_level_memory_consumption View 619 The session_level_memory_consumption View 619 Viewing Query Workfile Usage Information 620 Viewing the Database Server Practices when Creating Views 0 Working with View Dependencies 776 Working with View Dependencies 0 Finding View Dependencies 776 Finding Direct View Dependencies on a Table 777 Finding Direct Dependencies Listing View Schemas 778 Listing View Definitions 779 Listing Nested Views 780 Example Data 781 About View Storage in Greenplum Database 782 About View Storage in Greenplum Database 0 Where View Dependency

Memory Usage Information 610 Creating the session_level_memory_consumption View 610 The session_level_memory_consumption View 610 Viewing Query Workfile Usage Information 611 Viewing the Database Server Practices when Creating Views 0 Working with View Dependencies 767 Working with View Dependencies 0 Finding View Dependencies 767 Finding Direct View Dependencies on a Table 768 Finding Direct Dependencies Listing View Schemas 769 Listing View Definitions 770 Listing Nested Views 771 Example Data 772 About View Storage in Greenplum Database 773 About View Storage in Greenplum Database 0 Where View Dependency

Memory Usage Information 542 Creating the session_level_memory_consumption View 542 The session_level_memory_consumption View 542 Viewing Query Workfile Usage Information 543 Viewing the Database Server Practices when Creating Views 0 Working with View Dependencies 699 Working with View Dependencies 0 Finding View Dependencies 699 Finding Direct View Dependencies on a Table 700 Finding Direct Dependencies Listing View Schemas 701 Listing View Definitions 702 Listing Nested Views 703 Example Data 704 About View Storage in Greenplum Database 705 About View Storage in Greenplum Database 0 Where View Dependency