Enterprise Edition Home
|
Express Edition Home
|
Previous Page
|
Next Page
Parallel Database Query
In This Chapter
What Parallel Database Query (PDQ) Is
Structure of a PDQ Query
Database Server Operations That Use PDQ
Parallel Delete
Parallel Inserts
Explicit Inserts with SELECT...INTO TEMP
Implicit Inserts with INSERT INTO...SELECT
Parallel Index Builds
Parallel User-Defined Routines
Hold Cursors That Use PDQ
SQL Operations That Do Not Use PDQ
Update Statistics
SPL Routines and Triggers
Correlated and Uncorrelated Subqueries
OUTER Index Joins
Remote Tables
Memory Grant Manager
Allocating Resources for Parallel Database Queries
Limiting the Priority of DSS Queries
Limiting the Value of PDQ Priority
Maximizing OLTP Throughput
Conserving Resources
Allowing Maximum Use of Parallelism
Determining the Level of Parallelism
Limits on Parallelism Associated with PDQ Priority
Using SPL Routines
Adjusting the Amount of Memory
Limiting the Number of Concurrent Scans
Limiting the Maximum Number of Queries
Managing Applications
Using SET EXPLAIN
Using OPTCOMPIND
Using SET PDQPRIORITY
User Control of Resources
DBA Control of Resources
Controlling Resources Allocated to PDQ
Controlling Resources Allocated to Decision-Support Queries
Monitoring PDQ Resources
Using the onstat Utility
Monitoring MGM Resources
Monitoring PDQ Threads
Monitoring Resources Allocated for a Session
Using SET EXPLAIN
Enterprise Edition Home
|
Express Edition Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]