Virtual Schemas: Added Pushdown of COUNT of Tuple
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10804 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.1.0, Exasol 7.0.4 |
| Resolution Date | 2020-11-26 |
Description
Virtual Schemas are able to push certain aspects of a query into the source system, which can result in improved performance for the virtual schema query.
The pushdown of COUNT(*) and COUNT(exp) was already supported.
Improvement
Virtual schemas now support the pushdown of COUNT of a tuple, e.g. COUNT((exp1, exp2)), into the source system. The virtual schema API has been extended to support this.
To take advantage of this improvement, you must
- update the database to the fix version and
- update the virtual schema adapter.