Hp Neoview Release 2.4 Software Manuale Utente Scaricare il pdf (Pagina 79)

you to in-depth information about the operators in the Neoview Query Guide. For information

about the EXPLAIN statement, see the Neoview SQL Reference Manual.

For information about improving query plans, see Tips for Query Plan Performance

Improvements.

Operator Groups

Each operator is identified in the query tree by an icon that identifies the group type. These are

the operator groups:

File Scan

Root

Exchange

Insert

Split Top

Partition Access

Tuple

ESAM Subset

Group By

Merge Union

Default

ESAM Unique

Join

Sort

Data Mining

Query Workbench Query Details 79

1 2 ... 74 75 76 77 78 79 80 81 82 83 84 ... 93 94

HP Part Number: 586321-001 1
Published: September 2009 1
Table of Contents 3
4 Table of Contents 4
Table of Contents 5 5
6 Table of Contents 6
Learn About This Document 7
Intended Audience 8
Related Documentation 8
Resources on the Web 9
Send Feedback to HP 9
2 Use the Workspace 17
Create a New Workspace 18
Start a Workspace 18
Save a Workspace Layout 19
Close a Workspace 19
Open a Workspace 19
The Workspace At a Glance 19
Rename a Workspace 20
Lock a Workspace 20
Set Workspace Options 20
Add Another Workspace 21
22 Use the Workspace 22
3 Use the Workspace Toolbox 23
24 Use the Workspace Toolbox 24
Timeline Controller 25
4 Use the Neoview Pane 27
Adjust Time Settings 28
Delete Tools and Graphs 28
Add a Customized View 28
Rename a Customized View 28
Delete a View 28
Other Tasks on Graphs 29
5 Use the Live View Pane 31
Configure Live View Options 32
Customize the Live View 32
Kill Queries 32
Actions on Live View Queries 33
Notification Bubbles 33
Pause the Display 33
Thresholds and Alerts 33
34 Use the Live View Pane 34
Workspaces Tab 35
Conditions Tab 35
Running Threshold Rules 36
Monitoring Queries 37
Time-Based Metrics 39
Rate-Based Metrics 40
Compile-Time Metrics 40
Run-Time Metrics 41
Miscellanous Facts 43
Rule Warnings 43
Per-Table Statistics 43
Get Query Text 44
46 Use the Live View Pane 46
Services Details Log File 47
Neoview WMS Configuration 48
WMS Configuration Dialog 48
Managing Services 49
Add a New WMS Service 50
Alter an Existing WMS Service 52
Delete a WMS Service 53
Start a WMS Service 53
Managing Rules 54
Add a New Connection Rule 56
Example: 57
Add a New Compilation Rule 58
Add a New Execution Rule 59
Alter Existing Rule 61
Delete a Rule 61
Associate Rules to Services 61
Managing Admin Roles 62
Save/Export WMS Configuration 63
Character Set Support 64
6 Use the Triage Space Pane 65
Triage Space Settings 66
Query Candlestick Graph 67
Triage Space Button Panel 68
Filter the Queries 68
Dimensions: 69
Identifiers: 69
Triage Space Data Grid 70
Triage Space Query Details 70
• Type: Metrics 71
• Type: Miscellaneous 72
• Type: Time 72
DescriptionField 73
7 Use the Query Workbench 75
Query List 76
SQL Text 77
Statistics 78
Query Workbench Query Details 78
Operator Groups 79
Process Boundaries 80
Execute Output 82
Improve File Scan Performance 83
9 Keyboard Shortcuts 87
88 Keyboard Shortcuts 88
Glossary 89
90 Glossary 90
92 Index 92

Commenti su questo manuale

Nessun commento

Hp Neoview Release 2.4 Software Manuale Utente Pagina 79

Commenti su questo manuale

Prodotti e manuali riguardandi Software Hp Neoview Release 2.4 Software