HP Integrity NonStop H-Series - Manual (Page 10)

Contents x
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