Home
|
Previous Page
|
Next Page
Improving UDR Performance
In This Chapter
Optimizing a User-Defined Routine
Optimizing an SPL Routine
Optimization Levels
Automatic Optimization
Updating Statistics for an SPL Routine
Optimizing Functions in SQL Statements
Calculating the Query Plan
Specifying Cost and Selectivity
Constant Cost and Selectivity Values
Dynamic Cost and Selectivity Values
Calculating Cost
Selectivity and Cost Examples
Extending UPDATE STATISTICS
Using UPDATE STATISTICS
Support Functions for UPDATE STATISTICS
The stat Data Type
The statcollect() Function
The statprint() Function
Example of User-Defined Statistics Functions
Using Negator Functions
Using a Virtual-Processor Class
Choosing a Virtual-Processor Class
CPU Virtual-Processor Class
User-Defined Virtual-Processor Class (C)
JVM Virtual-Processor Class (Java)
Using Virtual Processors with UDRs Written in C
Managing Virtual Processors
Adding and Dropping Virtual Processors
Monitoring Virtual-Processor Classes
Parallel UDRs
Executing UDRs in Parallel
Execution of a UDR in a Query Expression
FastPath Execution of a UDR in a DataBlade API (C)
Implicit UDR Execution of a User-Defined Aggregate
Implicit UDR Execution of a Comparison Operator
Implicit Execution of an Assign UDR
Execution of a Comparison UDR for Sort
Execution of a UDR by an Index on a UDT column
Enabling Parallel UDRs
Specifying the PARALLELIZABLE Modifier
Writing PDQ Thread-Safe UDRs
Turning On PDQ and Reviewing Other Configuration Parameters
Step-By-Step Procedure to Enable Parallel UDRs
Setting the Number of Virtual Processors
Monitoring Parallel UDRs
Memory Considerations
Memory Durations for C UDRs
Stack-Size Considerations (Ext)
Virtual-Memory Cache for Routines
The sysprocedures System Catalog Table
UDR Cache
I/O Considerations
Isolating System Catalog Tables
Balancing the I/O Activities
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]