HP Neoview Release 2.4 Software - Manual (Page 6)

Query Workbench Query Details.........................................................................................................78
Explain Plan.....................................................................................................................................78
Operator Groups........................................................................................................................79
Analyze the Explain Plan Through the Grid...................................................................................80
About the ESP_EXCHANGE and HYBRID_HASH_JOIN Operators............................................80
Process Boundaries..........................................................................................................................80
Process Architecture For a Query..............................................................................................80
Plan Summary and Operator Details..............................................................................................81
Execute Output................................................................................................................................82
8 Tips for Query Plan Performance Improvements.......................................................83
Determine the Base Table Access Strategy...........................................................................................83
When to Change the Default Aggregate Function...............................................................................83
Improve File Scan Performance............................................................................................................83
Improve Index Scan Performance.........................................................................................................84
Significance of Hash Key Columns.......................................................................................................84
Significance of Primary Key Columns..................................................................................................85
9 Keyboard Shortcuts......................................................................................................87
General Shortcuts..................................................................................................................................87
Menu Shortcuts.....................................................................................................................................87
Workspace Shortcuts.............................................................................................................................87
View Shortcuts......................................................................................................................................87
Triage Space Shortcuts..........................................................................................................................87
Glossary............................................................................................................................89
Index.................................................................................................................................91
6 Table of Contents