Owner manual

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