IBM® Informix® Warehouse Accelerator, Version 12.10

Supported and unsupported joins

Specific join types, join predicates, and join combinations are supported by Informix® Warehouse Accelerator.

Supported joins

Equality join predicates, INNER joins, and LEFT OUTER joins are the supported join types.

The fact table referenced in the query must be on the left side of the LEFT OUTER join.

Any filter on a dimension table that you use in a LEFT OUTER join must be a post-join filter. A post-join filter is in the WHERE clause after the join.

Unsupported joins

The following joins are not supported:
  • RIGHT OUTER joins
  • FULL OUTER joins
  • Informix outer joins
  • Joins that do not use an equality predicate
  • Subqueries
Parent topic: Overview of Informix Warehouse Accelerator
Related concepts:
Queries that benefit from acceleration

Examples exchange | Troubleshooting

To find the PDF, see Publications for IBM Informix Warehouse Accelerator 12.10.
For the release notes, see the Release Notes topic.
timestamp Release date: March 2015