Netezza Performance Server SQL analytic functions

Many of the ANSI SQL:1999 standard analytic functions and some extensions are supported. Using analytic functions in your business intelligence queries provides the following benefits:

• Improved query processing

  Using these functions results in better performance because the system no longer must conduct complex procedural processing and instead can conduct simple SQL queries.

• Enhanced productivity

  You can do complex analysis with clearer, more concise code. The code is quicker to formulate and easy to maintain.

• Easy to learn

  The functions use existing aggregate functions and thus use known syntax.

• Standardized syntax

  Because these functions are part of the ANSI standard, they are supported in many software packages.

The Netezza Performance Server system also supports the development and use of user-defined functions and aggregates. This feature is described in the IBM® Netezza® User-Defined Functions Developer's Guide.