HP NonStop G-Series User Manual
Page 17
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