Server characteristics affecting pushdown opportunities

Server characteristics that affect pushdown include SQL support, collating sequence, federated server options, and type and function mappings.

The factors that affect pushdown opportunities for nonrelational data sources are different than the factors that affect pushdown opportunities for relational data sources. The SQL dialect is not a factor for most nonrelational data sources, since they do not use SQL.

The following topics describe the data source-specific factors that can affect pushdown opportunities.