HP NonStop G-Series - Manual (Page 16)

Contents xiv
Display Dependencies ................................................................................... 14-10
Assign the New Name................................................................................... 14-11
Managing Index Comments ...............................................................14-11
Choose an Index ........................................................................................... 14-12
Add, Change, or Delete Index Comments...................................................... 14-12
Save the Index Comment .............................................................................. 14-12
Viewing Index Statistics ....................................................................14-13
CHAPTER 15. MANAGING TABLE PARTITIONS ..................... 15-1
Designing Table Partitions.................................................................. 15-1
Choose Base Table ......................................................................................... 15-2
Choose Table Partition.................................................................................... 15-2
Choose Partonly.............................................................................................. 15-3
Manual Design................................................................................................ 15-3
Auto Design.................................................................................................... 15-3
Manual Design ................................................................................... 15-3
Automatic Design............................................................................... 15-5
Display Dependencies ..................................................................................... 15-6
View Partitions................................................................................... 15-6
Choose Base Table ......................................................................................... 15-7
Assign Sample Rate ........................................................................................ 15-7
Compute Row Distribution ............................................................................. 15-7
Adding Partitions................................................................................ 15-7
Assign the Number of Partitions...................................................................... 15-8
Assign Volumes .............................................................................................. 15-8
Assign Catalogs .............................................................................................. 15-9
Assign File Attributes.................................................................................... 15-10
Display Dependencies ................................................................................... 15-10
Add the Partitions ......................................................................................... 15-10
Altering Partitions .............................................................................15-11
Display Dependencies ................................................................................... 15-12
Alter the Partitions........................................................................................ 15-12
Drop Partitions ..................................................................................15-12
Choose Partition: .......................................................................................... 15-13
Display Dependencies ................................................................................... 15-13
Drop the Partitions........................................................................................ 15-13
Perform a Simple Move.....................................................................15-14
Choose a Table ............................................................................................. 15-14
Select the Partition........................................................................................ 15-15
Assign Name and Location............................................................................ 15-15
Assign File Attributes.................................................................................... 15-16
Display Dependencies ................................................................................... 15-16
Move the Partition ........................................................................................ 15-16