Introduction

You can use the user-defined functions to create custom functions, aggregates, and shared libraries that run on Netezza Performance Server systems and perform specific types of analysis for your business reporting and data queries.

The functions use the Netezza Performance Server massively parallel processing (MPP) environment to accelerate analysis of data and to offer new and unique types of analysis. Because user-defined functions enable data to be processed directly on the Netezza Performance Server system, you can reduce or eliminate data movement to other systems for analysis, which reduces the overall processing time.

The Netezza Performance Server support for user-defined functions generally follows the model that is used in the 2003 SQL Standard for SQL-Invoked Routines.