Table of Contents iv
Greenplum Database Administrator Guide 4.0 - Contents
Dropping a Schema ...................................................................68
System Schemas .......................................................................68
Creating and Managing Tables ........................................................68
Creating a Table ........................................................................69
Altering a Table .........................................................................75
Dropping a Table .......................................................................77
Partitioning Large Tables.................................................................77
Understanding Table Partitioning in Greenplum Database..........77
Deciding on a Table Partitioning Strategy ..................................78
Creating Partitioned Tables ........................................................79
Loading Partitioned Tables .........................................................82
Verifying Your Partition Strategy................................................83
Viewing Your Partition Design ....................................................84
Maintaining Partitioned Tables ...................................................84
Creating and Using Sequences ........................................................88
Creating a Sequence..................................................................88
Using a Sequence ......................................................................88
Altering a Sequence...................................................................89
Dropping a Sequence.................................................................89
Using Indexes in Greenplum Database ............................................89
Index Types...............................................................................91
Creating an Index......................................................................92
Examining Index Usage .............................................................92
Managing Indexes .....................................................................93
Dropping an Index.....................................................................94
Creating and Managing Views..........................................................94
Creating Views...........................................................................94
Dropping Views..........................................................................94
Chapter 10: Managing Data.........................................................96
About Concurrency Control in Greenplum Database ........................96
Inserting New Rows ........................................................................97
Updating Existing Rows ...................................................................98
Deleting Rows .................................................................................98
Truncating a Table .....................................................................99
Working With Transactions..............................................................99
Transaction Isolation Levels.......................................................99
Vacuuming the Database ..............................................................101
Configuring the Free Space Map .............................................. 101
Chapter 11: Querying Data ........................................................102
Defining Queries ...........................................................................102
SQL Lexicon.............................................................................102
SQL Value Expressions ............................................................ 102
Using Functions and Operators......................................................111
Using Functions in Greenplum Database ..................................111
User-Defined Functions............................................................ 112
Built-in Functions and Operators..............................................112
Query Profiling ..............................................................................119
Reading EXPLAIN Output ......................................................... 120
- 1
- 2
前往页