Owner manual

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