Query block example: Sales count
In this query, the query block SELECT COUNT(*)
FROM sales
is sent to Informix® Warehouse Accelerator for
acceleration.
The query block SELECT COUNT(*) FROM systables
does
not qualify for acceleration.
SELECT COUNT(*) FROM sales UNION ALL SELECT COUNT(*) FROM systables;
In this example, both SELECT query blocks are sent to Informix® Warehouse Accelerator for processing. Each query block is sent separately.
SELECT COUNT(*) FROM sales UNION ALL SELECT COUNT(*) FROM sales_returns;