Netezza Connector > Netezza ODBC pushdown optimization > Pushdown optimization functions
  

Pushdown optimization functions

The following table summarizes the availability of pushdown functions in a Netezza source or target:
Functions
Pushdown Type
ABS()
Source, Full
AVG()
Source, Full
COS()
Source, Full
COUNT()
Source, Full
DATE_COMPARE()
Source, Full
DECODE()
Source, Full
EXP()
Source, Full
IIF()
Source, Full
IN()
Source, Full
ISNULL()
Source, Full
LOWER()
Source, Full
MAX()
Source, Full
MIN()
Source, Full
POWER()
Source, Full
SIN()
Source, Full
SQRT()
Source, Full
SUM()
Source, Full
TAN()
Source, Full
TO_DECIMAL()
Source, Full
TO_FLOAT()
Source, Full
TO_INTEGER()
Source, Full
UPPER()
Source, Full