HP Neoview Release 2.4 Software User Manual
Page 92
Query Workbench pane, 11
start, 13
Triage Space pane, 11
Neoview platform
connect through ODBC, 21
Neoview Query Viewer
Neoview Query Workbench
Query Workbench pane, 75
start, 14
O
Operators
details, 81
ESP_EXCHANGE, 80
FILE_SCAN, 83
P
Performance
aggregate function, 83
base table access, 83
improving file_scan, 83
improving index_scan, 84
significance of hash key columns, 84
significance of primary key columns, 85
Process architecture
described, 80
ESAM process, 80
ESP process, 80
MXCMP process, 80
MXOSRVR process, 80
process boundaries, 81
Processing Node Queue Length tool, 24
Processing Node Utilization tool, 24
Q
Queries
analyze Explain plan, 80
checked, 76
difference between checked and selected, 76
execute in NCI, 14
executed output, 82
HYBRID_HASH_JOIN, 80
plan summary, 81
selected, 76
view Explain plan, 78
Query candlestick graph
description, 67
right-click menu, 67
Query details
Live View pane, 37
Query Workbench pane, 78
Triage Space pane, 70
Query plans
operators, 80
process architecture, 80
process boundaries, 80
Query Workbench pane
at a glance, 75
query details, 78
query list, 76
settings, 75
SQL text, 77
statistics, 78
Query, process architecture, 80
R
Reconnect to Neoview platform, 22
Repositories
switching, 66
Resources on the web
applications, 9
documentation, 9
S
Save, WMS configuration, 63
Selected queries, 76
System I/O Activity tool, 24
System Metrics tool, 24
T
Threshold Rule Creation Wizard
Actions tab, 36
Conditions tab, 35
running rules, 36
Workspaces tab, 35
Timeline controller, 25
Timeout settings
adjust, 22
Triage Space pane
at a glance, 65
data grid, 70
data grid right-click menu, 70
filter items, 68
load queries to Query Workbench, 73
monitor queries, 70
query candlestick graph, 67
query details, 70
statement counters, 73
toggle commands, 68
workload filter properties, 68
U
Uninstall
Neoview Performance Analysis Tools, 13
V
Views
add customized view, 28
delete customized view, 28
rename customized view, 28
W
WMS configuration
save or export, 63
WMS Service Rules
add admin role, 62
92
Index