HP NonStop G-Series - Manual (Page 10)

Contents viii
Choose a Query ................................................................................................ 7-3
Display Plan Details .......................................................................................... 7-4
Display Statistics............................................................................................... 7-5
Table Statistics.................................................................................................. 7-6
Simulate Production Statistics ........................................................................... 7-9
Tune the Query............................................................................................... 7-10
Modify Control Options .................................................................................. 7-11
View Explain Plans ......................................................................................... 7-14
Execute the Query .......................................................................................... 7-14
Analyzing Ad Hoc Queries ................................................................. 7-15
Create a Query................................................................................................ 7-15
Modify Control Options .................................................................................. 7-16
View Explain Plan........................................................................................... 7-16
Display Statistics............................................................................................. 7-17
Simulate Production Statistics ......................................................................... 7-17
Execute Query ................................................................................................ 7-18
Save the Query ............................................................................................... 7-18
CHAPTER 8. MANAGING DATA ....................................................... 8-1
Querying Data ...................................................................................... 8-1
Querying a Database ......................................................................................... 8-2
Copying Data ....................................................................................... 8-6
Define Source and Destination .......................................................................... 8-6
Specify Control Options.................................................................................... 8-7
Define Input-File Options.................................................................................. 8-8
Define Output-File Options ............................................................................... 8-9
Specify Display Options .................................................................................... 8-9
Specify Move Options....................................................................................... 8-9
Perform the Copy............................................................................................ 8-11
Loading Data...................................................................................... 8-11
Define Source and Destination ........................................................................ 8-12
Specify Control Options.................................................................................. 8-12
Define Input-File Options................................................................................ 8-13
Specify Key Sequence Options........................................................................ 8-14
Enable Parallel Execution................................................................................ 8-15
Specify Move Options..................................................................................... 8-15
Load the Data ................................................................................................. 8-17
CHAPTER 9. AUDITING COMMAND EXECUTION....................... 9-1
Choose Users ....................................................................................... 9-2
Choose Object...................................................................................... 9-2
Choose Period ...................................................................................... 9-3
Display Audit Trail............................................................................... 9-3