HP Neoview Release 2.5 Software User Manual
Page 112
exit, 14
install, 13
Neoview Performance Analyzer, 11
Neoview Query Viewer, 12, 35
Neoview Query Workbench, 12, 89
Neoview Performance Analyzer
Live View pane, 11
Neoview pane, 11
process boundaries, 99
Query Workbench pane, 11
start, 13
Triage Space pane, 11
Neoview platform, connect through ODBC, 22
Neoview Query Viewer
Neoview Query Workbench
Query Workbench pane, 89
start, 14
O
Operators
details, 99
ESP_EXCHANGE, 98
FILE_SCAN, 101
P
Performance
aggregate function, 101
base table access, 101
improving file_scan, 101
improving index_scan, 102
significance of hash key columns, 102
significance of primary key columns, 103
Process architecture
described, 98
ESAM process, 98
ESP process, 98
MXCMP process, 98
MXOSRVR process, 98
process boundaries, 99
Processing Node Queue Length tool, 28
Processing Node Utilization tool, 28
Q
Queries
analyze Explain plan, 98
checked, 93
difference between checked and selected, 93
executed output, 100
HYBRID_HASH_JOIN, 98
plan summary, 99
selected, 93
view Explain plan, 96
Query candlestick graph
description, 79
shortcut menu, 79
Query details
Live View pane, 41
Query Workbench pane, 96
Triage Space pane, 82
Query plans
operators, 98
process architecture, 98
process boundaries, 98
Query Workbench pane
at a glance, 89
query details, 96
query list, 92
settings, 92
SQL text, 93
statistics, 95
table statistics, 95
Query, process architecture, 98
R
Reconnect to Neoview platform, 25
Repositories. switching, 78
Resources on the web
applications, 9
documentation, 9
S
Save, WMS configuration, 75
Selected queries, 93
Session statistics, 43
SQL Defaults field, 62, 64
Stop immediately check box, 64
System I/O Activity tool, 28
System Metrics tool, 28
T
Threshold Rule Creation Wizard
Actions tab, 39
Conditions tab, 39
running rules, 40
Workspaces tab, 39
Timeline controller, 29
Timeout settings, adjust, 24
Triage Space pane
at a glance, 77
data grid, 82
data grid shortcut menu, 82
filter items, 80
load queries to Query Workbench, 87
monitor queries, 82
query candlestick graph, 79
query details, 82
statement counters, 87
toggle commands, 80
workload filter properties, 80
V
Views
add customized view, 32
delete customized view, 32
rename customized view, 32
112
Index