Hp Neoview Release 2.5 Software Manuel d'utilisateur télécharger pdf (Page 91)

• Table Statistics shows details about all the tables and statistics about all columns in the

tables used in the current Explain query plan. For more information, see “Table Statistics”

(page 95).

• Query Details shows an organized layout of an Explain plan for the current query in the

SQL text box. It contains two tabs: Explain Plan and Execute Output. For more information,

see “Query Workbench Query Details” (page 96).

The Query Workbench At a Glance 91

1 2 ... 86 87 88 89 90 91 92 93 94 95 96 ... 113 114

User Guide 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
Neoview Customer Library 8
Resources on the Web 9
Send Feedback to HP 9
Execute Queries 14
2 Use the Workspace 15
Create a New Workspace 16
Start a Workspace 16
Save a Workspace Layout 17
Close a Workspace 17
Open a Workspace 17
The Workspace At a Glance 17
Workspace Title 18
Menu Bar Commands 18
Use the Edit Menu Options 19
Use the Tools Menu Options 20
Use the Windows Menu Options 20
Use the Display Menu Options 20
Use the Help Menu Options 20
Rename a Workspace 21
Lock a Workspace 21
Set Workspace Options 21
Add Another Workspace 22
3 Use the Workspace Toolbox 27
28 Use the Workspace Toolbox 28
Timeline Controller 29
4 Use the Neoview Pane 31
Other Tasks on Graphs 33
5 Use the Live View Pane 35
Configure Live View 36
Customize the Live View 36
Kill Queries 36
Actions on Live View Queries 37
Notification Bubbles 37
Pause the Display 37
Thresholds and Alerts 37
38 Use the Live View Pane 38
Workspaces Tab 39
Conditions Tab 39
Actions Tab 39
Running Threshold Rules 40
Configuration 41
Session Statistics 43
Time-Based Metrics 46
Rate-Based Metrics 47
Compile-Time Metrics 48
Run-Time Metrics 49
Miscellanous Facts 50
Rule Warnings 52
Per-Table Statistics 52
Get Query Text 52
Services Details Log File 55
Neoview WMS Configuration 56
WMS Configuration Dialog 56
Managing Services 58
Services User Interface 60
Add a New WMS Service 61
Alter an Existing WMS Service 62
Delete a WMS Service 64
Start a WMS Service 64
Stop a WMS Service 64
Managing Rules 65
Rules Summary Interface 66
Add a New Rule 67
Services Guide 69
Example: 69
Associate Rules to Services 73
Managing Admin Roles 74
Save/Export WMS Configuration 75
Character Set Support 76
7 Use the Triage Space Pane 77
Switching Repositories 78
Query Candlestick Graph 79
Triage Space Button Panel 80
Filter the Queries 80
Dimensions: 81
Identifiers: 81
Triage Space Data Grid 82
Triage Space Query Details 82
• Type: Metrics 83
• Type: Miscellaneous 85
• Type: Time 86
8 Use the Query Workbench 89
90 Use the Query Workbench 90
Query Workbench Settings 92
Query List Box 92
SQL Text Box 93
Enter a New Query 94
Schema Drop Down 94
Maximum Rows Fetched 94
Statistics 95
Table Statistics 95
Query Workbench Query Details 96
Operator Groups 97
Process Boundaries 98
Execute Output 100
Improve File Scan Performance 101
10 Keyboard Shortcuts 105
106 Keyboard Shortcuts 106
Glossary 107
108 Glossary 108
112 Index 112

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.5 Software Manuel d'utilisateur Page 91

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.5 Software