User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 xv
Performing a One-Way Split..............................................................15-17
Choose Table................................................................................................15-17
Assign Name and Location............................................................................ 15-17
Assign File Attributes.................................................................................... 15-18
Display Dependencies ................................................................................... 15-18
Move the Partition........................................................................................ 15-19
Performing a Two-Way Split.............................................................15-19
Choose Table................................................................................................15-20
Assign Names and Locations......................................................................... 15-20
Assign File Attributes.................................................................................... 15-20
Assign Primary-Key Values........................................................................... 15-21
Display Dependencies ................................................................................... 15-21
Move the Partition........................................................................................ 15-21
CHAPTER 16. MANAGING INDEX PARTITIONS...................... 16-1
Designing Index Partitions.................................................................. 16-1
Choose Base Index .........................................................................................16-2
Choose Index Partition....................................................................................16-2
Choose Partonly..............................................................................................16-3
Manual Design................................................................................................16-3
Auto Design....................................................................................................16-3
Manual Design................................................................................... 16-4
Automatic Design............................................................................... 16-5
Display Dependencies .....................................................................................16-5
View Partitions................................................................................... 16-5
Choose Index..................................................................................................16-6
Assign Sample Rate ........................................................................................16-6
Compute Row Distribution .............................................................................16-6
Adding Partitions................................................................................ 16-7
Assign the Number of Partitions......................................................................16-7
Assign Volumes..............................................................................................16-7
Assign Catalogs ..............................................................................................16-8
Assign File Attributes......................................................................................16-9
Display Dependencies .....................................................................................16-9
Add the Partitions...........................................................................................16-9
Altering Partitions .............................................................................16-10
Display Dependencies ................................................................................... 16-11
Alter the Partitions........................................................................................16-11
Drop Partitions..................................................................................16-11
Choose Partition:.......................................................................................... 16-12
Display Dependencies ................................................................................... 16-12
Drop the Partitions........................................................................................16-13
Perform a Simple Move.....................................................................16-13