User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 ix
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