In This Chapter

This chapter describes performance considerations for UDRs and includes the following topics:

• Optimizing a User-Defined Routine
• Optimizing Functions in SQL Statements
• Extending UPDATE STATISTICS
• Using Negator Functions
• Using a Virtual-Processor Class
• Parallel UDRs
• Memory Considerations
• I/O Considerations