HP NonStop G-Series - Manual (Page 15)

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 xiii
Dropping an Index.............................................................................. 14-8
Choose an Index ............................................................................................. 14-9
Display Dependencies ..................................................................................... 14-9
Drop the Index.............................................................................................. 14-10
Renaming an Index............................................................................14-10
Choose an Index ........................................................................................... 14-11
Display Dependencies ................................................................................... 14-11
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-13
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