IN Criteria Pushdown Behavior for DV

Solution Verified - Updated -

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.1

Issue

  • if the number of elements in the IN Criteria is less than or equal to 1000 (due to the default MaxInCriteriaSize), the IN Criteria is pushdown. However, if the number of elements is greater than 1000, the IN Criteria is not pushdown and causing a full table load.

Resolution

The logic for IN criteria and batches is only there for Dependent Joins not end-user query criteria. This feature will be added to Data Virtualization version 6.2 Update 01.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.