Creating and Managing Views 766 Creating and Managing Views 0 Creating Views 766 Dropping Views 766 Best Practices when Creating Views 766 Best Practices when Creating Views 0 Working with View Dependencies Dependencies on a Table Column 769 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 Materialized Views 773 Creating and Managing Materialized Views 0 Creating Materialized Views 774 VMware Greenplum v6.18 Documentation VMware, Inc. 44 Refreshing or Disabling Materialized Views 775 Dropping

Creating and Managing Views 775 Creating and Managing Views 0 Creating Views 775 Dropping Views 775 Best Practices when Creating Views 775 Best Practices when Creating Views 0 Working with View Dependencies Dependencies on a Table Column 778 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 Materialized Views 782 Creating and Managing Materialized Views 0 Creating Materialized Views 783 VMware Greenplum v6.19 Documentation VMware, Inc. 45 Refreshing or Disabling Materialized Views 784 Dropping

Creating and Managing Views 698 Creating and Managing Views 0 Creating Views 698 Dropping Views 698 Best Practices when Creating Views 698 Best Practices when Creating Views 0 Working with View Dependencies Dependencies on a Table Column 701 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 Materialized Views 705 Creating and Managing Materialized Views 0 Creating Materialized Views 706 VMware Greenplum v6.17 Documentation VMware, Inc. 40 Refreshing or Disabling Materialized Views 707 Dropping

a table 763 Dropping an Index 764 Creating and Managing Views 764 Creating Views 764 Dropping Views 764 Best Practices when Creating Views 765 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc 768 Listing Nested Views 769 Example Data 770 About View Storage in Greenplum Database 771 Where View Dependency Information is Stored 771 Creating and Managing Materialized Views 772 Creating Materialized Materialized Views 773 Refreshing or Disabling Materialized Views 773 Dropping Materialized Views 773 Working with External Data 774 Accessing External Data with PXF 775 Defining External Tables 775

Greenplum 6 Cluster 473 Preparing Greenplum 4.3 and 5 Databases for Backup 475 About Migrating Views Created with lag()/lead() Functions 478 Backing Up and Restoring a Database 479 Completing the Migration a table 604 Dropping an Index 604 Creating and Managing Views 604 Creating Views 604 Dropping Views 605 Best Practices when Creating Views 605 VMware Greenplum 6 Documentation VMware by Broadcom 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 Materialized

Greenplum 6 Cluster 454 Preparing Greenplum 4.3 and 5 Databases for Backup 456 About Migrating Views Created with lag()/lead() Functions 459 Backing Up and Restoring a Database 460 Completing the Migration a table 575 Dropping an Index 575 Creating and Managing Views 575 Creating Views 575 Dropping Views 575 Best Practices when Creating Views 576 Working with View Dependencies 576 Finding View Dependencies Dependencies on a Table Column 578 Listing View Schemas 579 Listing View Definitions 579 Listing Nested Views 580 VMware Greenplum 6 Documentation VMware, Inc. 27 Example Data 581 About View Storage in Greenplum

Greenplum 6 Cluster 479 Preparing Greenplum 4.3 and 5 Databases for Backup 480 About Migrating Views Created with lag()/lead() Functions 484 Backing Up and Restoring a Database 485 Completing the Migration Index 598 Creating and Managing Views 598 Creating Views 598 Dropping Views 598 VMware Greenplum 6 Documentation VMware, Inc 25 Best Practices when Creating Views 599 Working with View Dependencies 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 Materialized

Greenplum 6 Cluster 462 Preparing Greenplum 4.3 and 5 Databases for Backup 464 About Migrating Views Created with lag()/lead() Functions 467 Backing Up and Restoring a Database 468 Completing the Migration a table 576 Dropping an Index 576 Creating and Managing Views 576 Creating Views 577 Dropping Views 577 Best Practices when Creating Views 577 Working with View Dependencies 577 Finding View Dependencies 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 Materialized

Greenplum 6 Cluster 388 Preparing Greenplum 4.3 and 5 Databases for Backup 389 About Migrating Views Created with lag()/lead() Functions 392 Backing Up and Restoring a Database 393 Completing the Migration Index 490 Creating and Managing Views 490 VMware Tanzu Greenplum 6 Documentation VMware, Inc 23 Creating Views 491 Dropping Views 491 Best Practices when Creating Views 491 Working with View Dependencies 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 Materialized

Greenplum 6 Cluster 459 Preparing Greenplum 4.3 and 5 Databases for Backup 461 About Migrating Views Created with lag()/lead() Functions 464 Backing Up and Restoring a Database 465 Completing the Migration a table 573 Dropping an Index 573 Creating and Managing Views 573 Creating Views 574 Dropping Views 574 Best Practices when Creating Views 574 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 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 Materialized