HP Integrity NonStop H-Series - Manual (Page 15)

dba/m Database Manager V7.1 User's Guide – 540156-001 xv
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