Nickname characteristics affecting pushdown opportunities

Nickname characteristics that affect pushdown include the local data type of a nickname column, federated column options, and materialized query tables.

There are several nickname-specific factors that can affect pushdown opportunities. The local data type of a nickname column can affect the number of possibilities in a joining sequence evaluated by the optimizer. Nicknames can be flagged with a column option to indicate the columns contain no trailing blanks. This gives the SQL compiler the opportunity to generate a more efficient form of a predicate for the SQL statement sent to the data sources.