HP Neoview Release 2.5 Software - Manual (Page 6)

Triage Space Query Details...................................................................................................................82
Triage Space Statement Counters.........................................................................................................87
Load Queries from the Triage Space to Query Workbench..................................................................87
8 Use the Query Workbench.........................................................................................89
Query Workbench Pane in NPA = Neoview Query Workbench..........................................................89
The Query Workbench At a Glance......................................................................................................89
Query Workbench Settings...................................................................................................................92
Query List Box......................................................................................................................................92
Difference Between Checked or Selected Queries...........................................................................93
SQL Text Box.........................................................................................................................................93
Execute or Explain the Selected Query............................................................................................94
Enter a New Query..........................................................................................................................94
Schema Drop Down.........................................................................................................................94
Maximum Rows Fetched.................................................................................................................94
Rename the Query...........................................................................................................................95
Statistics.................................................................................................................................................95
Table Statistics.......................................................................................................................................95
Query Workbench Query Details.........................................................................................................96
Explain Plan.....................................................................................................................................96
Operator Groups........................................................................................................................97
Analyze the Explain Plan Through the Grid...................................................................................98
About the ESP_EXCHANGE and HYBRID_HASH_JOIN Operators............................................98
Process Boundaries..........................................................................................................................98
Process Architecture For a Query..............................................................................................98
Plan Summary and Operator Details..............................................................................................99
Execute Output..............................................................................................................................100
9 Tips for Query Plan Performance Improvements.....................................................101
Determine the Base Table Access Strategy..........................................................................................101
When to Change the Default Aggregate Function.............................................................................101
Improve File Scan Performance..........................................................................................................101
Improve Index Scan Performance.......................................................................................................102
Significance of Hash Key Columns.....................................................................................................102
Significance of Primary Key Columns................................................................................................103
10 Keyboard Shortcuts..................................................................................................105
General Shortcuts................................................................................................................................105
Menu Shortcuts...................................................................................................................................105
Workspace Shortcuts...........................................................................................................................105
View Shortcuts....................................................................................................................................105
Triage Space Shortcuts........................................................................................................................105
Glossary.........................................................................................................................107
Index...............................................................................................................................111
6 Table of Contents